Benthicsoftware has a good series of editors.
They are all about US$30 a piece or so.
Not as powerfull as TOAD but if you are just doing PL/SQL Development they
work great.
>From: "Magaliff, Bill" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple re
Well, since someone else cares to mention it, I do use Procedure Builder,
Oracle's PL/SQL development tool from Developer and I like it a lot. The latest
version even does syntax highlighting, indentation, and "click on the error &
I'll show you where i
ase was at 8.1.7.2.5
I then applied 8.1.7.4.1 via the installer
I then copied the files that comprise 8.1.7.4.5 to my Oracle home
I then ran catalog, catproc and the other stuff from the 8.1.7.4.1 release
notes.
At this stage I queried product_component_version and the PL/SQL version
was shown a
Beware ... TORA is not free on Windows platform ... it is free however on
Linux ... Funny no once has mentioned Oracle's built-in editor that comes
with Forms ...
My preferences are
1. Vi
2. Vim
Raj
__
Rajendra Jamadagni MIS, ESPN
,LAST_CALL_ET
,PDML_ENABLED
,FAILOVER_TYPE
,FAILOVER_METHOD
,FAILED_OVER
,RESOURCE_CONSUMER_GROUP
,PDML_STATUS
,PDDL_STATUS
,PQ_STATUS FROM sys.V_$SESSION
-bill
-Original Message-
Sent: Wednesday, August 28, 2002 8:18 AM
To: Multiple recipients of list ORACLE-L
PL
W_WAIT_BLOCK#
,ROW_WAIT_ROW#
,LOGON_TIME
,LAST_CALL_ET
,PDML_ENABLED
,FAILOVER_TYPE
,FAILOVER_METHOD
,FAILED_OVER
,RESOURCE_CONSUMER_GROUP
,PDML_STATUS
,PDDL_STATUS
,PQ_STATUS FROM sys.V_$SESSION
-bill
-Original Message-
Sent: Wednesday, August 28, 2002 8:18 AM
To: Mul
can you please post URL for this program?
thx
bill
-Original Message-
Sent: Wednesday, August 28, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L
I really like Emace with PL/SQL+SQLplus mode.
It is KISS. :=)
mvh
HEnrik
--- [EMAIL PROTECTED] wrote:
> Hi All,
> wh
AD, but the licensing cost is pretty steep - $700 a
pop for the most pared down version. Quest was willing to offer us a
one-time half-price offer, but for the 50 users we were considering it still
comes out to over $15,000.
PL/SQL Developer does basically everything TOAD does (that our de
etty steep - $700 a
> pop for the most pared down version. Quest was willing to offer us a
> one-time half-price offer, but for the 50 users we were considering it
> still comes out to over $15,000.
>
> PL/SQL Developer does basically everything TOAD does (that our developers
> do,
we're currently looking into this, too
Our developers like TOAD, but the licensing cost is pretty steep - $700 a
pop for the most pared down version. Quest was willing to offer us a
one-time half-price offer, but for the 50 users we were considering it still
comes out to over $15,000.
P
I really like Emace with PL/SQL+SQLplus mode.
It is KISS. :=)
mvh
HEnrik
--- [EMAIL PROTECTED] wrote:
> Hi All,
> which is the best PL/SQL editor available
> as a trial version .
> the editor should support Oracle sql,PL/SQL
> and may or may not
>
PL/SQL Developer.
http://www.allroundautomations.nl/plsqldev.html
very very good.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel
Enviado el: miércoles, 28 de agosto de 2002 9:13
Para: Multiple recipients of list ORACLE-L
Asunto: RE: PL/SQL
Try free Toad at http://www.toadsoft.com/downld.html
regards
Ofer Harel
DBA team
Barak ITC
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L
Hi All,
which is the best PL/SQL
BDY.RTF
Description: RTF file
this stage I queried product_component_version and the PL/SQL version was shown as
8.1.7.3.
It seems no-one else has seen this.
I'll repeat the upgrade on 2 other databases (with and without JVM installed) and see
if I can learn more.
Thanks,
Bruce
-Original Message-
Sent: Tuesday,
IL PROTECTED]]
Sent: Tuesday, August 27, 2002 1:03 AM
To: Multiple recipients of list ORACLE-L
Subject:Oracle 81745 upgrade and PL/SQL version
Hi,
Yesterday I upgraded a database from 81725 to 81745 on W2K SP3 (the DB
doesn't have JVM in it).
Before the upgrade, product_component_
> Before the upgrade, product_component_version showed the PL/SQL
> version as version "8.1.7.2.0".
> After the upgrade, the PL/SQL version is shown as 8.1.7.3.
Hmmm, weird.
Mine is W2K, no SP, JVM installed.
8.1.7.0.0,upgraded to 8.1.7.4.1.
PL/SQL shows as 8.1.7.4.0
>
Hi,
Yesterday I upgraded a database from 81725 to 81745 on W2K SP3 (the DB doesn't have
JVM in it).
Before the upgrade, product_component_version showed the PL/SQL version as version
"8.1.7.2.0".
After the upgrade, the PL/SQL version is shown as 8.1.7.3.
The product_component_v
Tom - Thanks to you and everyone else for the great suggestions. He and I
are sitting down tomorrow to straighten this out. I was concerned that there
might be some PL/SQL oddity that I wasn't aware of (he is a pretty good
PL/SQL programmer). I appreciate your ruling that out.
Dennis Wil
---
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replie
le Certified Professional
-Original Message-
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL
al Message-
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replie
but how about setting
> marketingcode to char(3) in the PL/SQL code snippet.
>
> I ran into this similar problem a couple days ago.
> Had a var as varchar2 in PL/SQL but in the table it
> was char. Changed my PL/SQL var to char, cursor in
> my
> code worked with ltrim and
um...just a thought but how about setting
marketingcode to char(3) in the PL/SQL code snippet.
I ran into this similar problem a couple days ago.
Had a var as varchar2 in PL/SQL but in the table it
was char. Changed my PL/SQL var to char, cursor in my
code worked with ltrim and rtrim functions
l: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Wednesday, August 21, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: PL/SQl question
Dennis,
In your PL/SQL program, did you try the RTRIM(date_field,' ') command?
I know that T
Check the definition of table C. It sounds like it is defined as CHAR(3) instead of
VARCHAR2(3). I would also check the PL/SQL for using CHAR instead of VARCHAR2 for
storing the value -- the trim should have eliminated this problem if it was put in the
right place.
Kevin Kennedy
First Point
In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.
PL/SQL snippets
<...snip...>
marketingcodeVARCHAR2(3);
<...snip...>
Dennis,
In your PL/SQL program, did you try the RTRIM(date_field,' ') command?
I know that TRIM is new, but I thought it needed additional parameters to
tell it what to trim.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, August 21, 2002 1
Is the field in question in table C defined as CHAR or VARCHAR2? If CHAR
that is why it is blank padded. Check datatype of variables
in pl/sql
Rick
at of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L
> I have a question for from one of my developers related to PL/SQL and how
> data is loaded.
&g
> I have a question for from one of my developers related to PL/SQL and how
> data is loaded.
>
> I have a field (marketcode) that is defined as VARCHAR2(3).
>
> I have a problem when I try to load the value of '20' into this field.
> All values with three charac
Check out the DBMS_JOB supplied plsql package
hth
connor
--- mac <[EMAIL PROTECTED]> wrote: > Any idea how to
schedule the execution of a PL/SQL
> package? and if a certain
> condition is acomplished to execute again (later in
> the night) the same
> package until the
Title: RE: how to schedule an execution in PL/SQL
hi!
i guess you should just have a look at the DBMS_JOB package!
i would start with reading the documentation of this standard
oracle package.
cheers
-dieter
-Original Message-
From: mac [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
I know how.
Ciprian MAFTEI
Telequote Network
Computer Systems Analyst
> Any idea how to schedule the execution of a PL/SQL package? and if a
> certain condition is acomplished to execute again (later in the
> night) the same package until the same condition is not anymore fulfilled
how to schedule the execution of a PL/SQL package? and if a certain
condition is acomplished to execute again (later in the night) the same
package until the same condition is not anymore fulfilled?
In PL/SQL not using a script for the operating system for example.
Ciprian MAFTEI
Telequote
Any idea how to schedule the execution of a PL/SQL package? and if a certain
condition is acomplished to execute again (later in the night) the same
package until the same condition is not anymore fulfilled?
In PL/SQL not using a script for the operating system for example.
Ciprian MAFTEI
What about SQLJ? You can wrap the entire PL/SQL code inside a SQLJ file and
use it as such without converting it into Java
HTH
Naveen
-Original Message-
Sent: Monday, August 19, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L
Does that actually convert PL/SQL to java, or just
Does that actually convert PL/SQL to java, or just put some sort of java
wrapper around the PL/SQL?
John
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: 16 August 2002 07:23
> To: Multiple recipients of list ORACLE-L
> Subject: Re:
Title: RE: pl/sql exception and whenever sqlerror
(see answer below - What a difference, a raise makes!)
> -Original Message-
> From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
>
> I have a command procedure running a sql*plus script that
> then runs a stored
> pr
't
go over to well...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 15, 2002 11:43 AM
> To: [EMAIL PROTECTED]; Multiple recipients of list
> ORACLE-L
> Subject: Re:R
I didn't see a reply to this but apparently Jdeveloper 9i can do this
>From the 91 Help file
Generating Java Source Code for Oracle Objects and PL/SQL Packages
To generate Java classes for an object type or package, right-click an
object type or package in JDeveloper's Navigator
2 1:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:RE: PL/SQL Editor.
>
> Scott,
> Dinosaur? When you have a good product it stays around for lng
> time.
> The complaints that I have with TOAD is that the pl/sql packages when
> converted to tex
DevPartner DB Tuner, Debugger & Profiler for PL/SQL from Compuware.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: [EMAIL PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Thursday, Augus
-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 15, 2002 11:43 AM
> To: [EMAIL PROTECTED]; Multiple recipients of list
> ORACLE-L
> Subject: Re:RE: PL/SQL Editor.
>
> Scott,
>
> vi, your dinos
-Original Message-
>Scott,
>vi, your dinosaur side is showing!! *-)
Oh come on. He included vim. <;
Cheers,
Thom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farrell, Thomas M.Mr. NGB-ARNG
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
Scott,
Dinosaur? When you have a good product it stays around for lng
time.
The complaints that I have with TOAD is that the pl/sql packages when
converted to text have a lot of white space due to the formatting.
Designer is not as bad but still has white space. I like to have the
developers
[EMAIL PROTECTED]; Multiple recipients of list
> ORACLE-L
> Subject: Re:RE: PL/SQL Editor.
>
> Scott,
>
> vi, your dinosaur side is showing!! *-)
>
> Dick Goulet
>
> Reply Separator
> Subject:RE: PL/SQL Editor.
> A
t; [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, August 15, 2002 10:09 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject:PL/SQL Editor.
> >
> > Hello,
> >
> > I need a nice PL/SQL editor any advice ?
> >
> > Thx for any advice
&
[SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 15, 2002 10:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: PL/SQL Editor.
>
> Hello,
>
> I need a nice PL/SQL editor any advice ?
>
> Thx for any advice
>
> Regards
> W.B
>
> ___
Title: RE: PL/SQL Editor.
Hi,
I use Emacs with PL/SQL module and Sqlplus.el
Really nice and easy to use.
Best Regards
Henrik
-Original Message-
From: Place for oracle
To: Multiple recipients of list ORACLE-L
Sent: 8/15/2002 5:09 PM
Subject: PL/SQL Editor.
Hello,
I need a
I like RapidSQL from Embarcadero - but it's a bit pricy
for a pretty good and less expensive alternative try PL/SQL Developer from
allroundautomations
-bill
-Original Message-
Sent: Thursday, August 15, 2002 11:09 AM
To: Multiple recipients of list ORACLE-L
Hello,
I need a ni
vi or vim.
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Place for oracle [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 15, 2002 10:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: PL/SQL Editor.
>
> Hello,
>
Free OraEdit
http://www.dkgadvancedsolutions.com/oraedit.htm
JP
On Thursday 15 August 2002 17:09, you wrote:
> Hello,
>
> I need a nice PL/SQL editor any advice ?
>
> Thx for any advice
>
> Regards
> W.B
>
> __
>
-Original Message-
Sent: Thursday, August 15, 2002 11:09 AM
>I need a nice PL/SQL editor any advice ?
I prefer vi myself but your probably looking for something like
http://www.indus-soft.com/winsql/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farr
Hello,
I need a nice PL/SQL editor any advice ?
Thx for any advice
Regards
W.B
__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Place for
Good morning,
Does anybody know of a utility that can convert PL/SQL code to Java code??
Thanks in advance for any replies.
Barry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Barry Deevey
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Barb,
Hee hee! Oldest PL/SQL mistake in the book -- to handle an exception
improperly without passing it on...
It sounds like the duhveloper coded the exception block as follows:
exception
when others then
dbms_output.put_line('A serious error has occurred'
;
exception when others then raise_application_error( -20001,'An error');
end;
Regards,
Waleed
-Original Message-
Sent: Wednesday, August 14, 2002 6:08 PM
To: Multiple recipients of list ORACLE-L
OK, I admit up front I'm not a pl/sql programmer. And I really did try to
look t
OK, I admit up front I'm not a pl/sql programmer. And I really did try to
look this up. Honest.
Took me a VERY long time to figure this out, but here it is...
I have a command procedure running a sql*plus script that then runs a stored
procedure. (This is VMS, but I think it would wor
;Date: Tue, 13 Aug 2002 14:34:13 -0800
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >From: "Danny Hughes" <[EMAIL PROTECTED]>
> >Subject: nextval increments by 2 in pl/sql procedure
> >
> >
uest for the
value from the sequence by any other session.
Naveen
-Original Message-
Sent: Wednesday, August 14, 2002 4:04 AM
To: Multiple recipients of list ORACLE-L
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The
problem is that it incrrements the
the
value from the sequence by any other session.
Naveen
-Original Message-
Sent: Wednesday, August 14, 2002 4:04 AM
To: Multiple recipients of list ORACLE-L
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The
problem is that it incrrements the sequence by
nal Message --
>Date: Tue, 13 Aug 2002 14:34:13 -0800
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>From: "Danny Hughes" <[EMAIL PROTECTED]>
>Subject: nextval increments by 2 in pl/sql procedure
>
>
>hello a
hello all,
I have a pl/sql procedure that selects the nextval from a sequence. The problem is
that it incrrements the sequence by 2 in a pl/sql procedure. If I select the nextval
from a sqlplus session, it works fine.
here is partial code that I am using.
PROCEDURE NEWTRANSACTION
: Multiple recipients of list ORACLE-L
Hi All,
I am trying to send an Email using PL/SQL. (Oracle 8.1.7 and Solaris 5.8).
I tried to run the initplsj.sql and got the following error.
Can you guys tell me what should I do to correct this?
SQL> @initplsj.sql
call dbms_java.set_output(10
Hi All,
I am trying to send an Email using PL/SQL. (Oracle 8.1.7 and Solaris 5.8).
I tried to run the initplsj.sql and got the following error.
Can you guys tell me what should I do to correct this?
SQL> @initplsj.sql
call dbms_java.set_output(1)
*
ERROR at lin
seen this here
before, but can't find my notes, so please forgive this same old question...
I need to execute a system call from within a PL/SQL block. Specifically,
I am looking at starting out report request demons as part of a post startup
trigger. Help?
TIA,
John P Weatherman
Da
ommands from PL/SQL blocks
OK, I checked Google and my own old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old
question...
I need to execute a system call from within a PL/SQL block. Specifically,
I am looking at starting out report
oogle and my own old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old
question...
I need to execute a system call from within a PL/SQL block. Specifically,
I am looking at starting out report request demons as part of a post
startup
trigg
You have to write an external stored procedure (C, C++, Java) and call it
from your PL/SQL block.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 3:56 PM
> O
OK, I checked Google and my own old mail and I know I've seen this here
before, but can't find my notes, so please forgive this same old question...
I need to execute a system call from within a PL/SQL block. Specifically,
I am looking at starting out report request demons as part
I would guess because it's not part of PL/SQL.
The DBMS_SQL package and 'EXECUTE IMMEDIATE' both send
your SQL to the database engine.
You may recall the the engine running PL/SQL is separate from the
DBMS engine, at least through 8i.
Jared
sam d <[EMAIL PROTECTED
We have package for logging diferent errors like
1. user error -- for user defined exception
2. system error -- for system exception
3. other error -- for other error
4. debug -- for debug logging
every time an exception is caught , based on type a satus is returned to
calling program at the same
You can also use execute immediate in PL/SQL, depending on the version of
Oracle you are running.
RF
Robert G. Freeman - Oracle8i OCP
Oracle Database Architect
CSX Midtier Database Administration
Author:
Oracle9i RMAN Backup and Recovery (NEW! Oracle Press - Due Oct 2002!!)
Oracle9i New
Thanks!
> -Original Message-
> From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
> Sent: Thursday, July 11, 2002 5:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re:PL/Sql Error Handling Package
>
> Hanah,
>
> This is one procedure out of an e
L PROTECTED] Subject: PL/Sql Error Handl
Yes, But why then we can issue DLL in PL/SQL using
DBMS_SQL package.
-Original Message-
From: Alroy Mascranghe [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Why DDL is not allowed in PL/SQL
Maybe it
,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done using DBMS_SQL package.
Curious
Sam
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official
Sam,
If u r in 8i and above
You could use
execute immediate 'create table .';
Regards
Suhen
Hi List,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done using DBMS_SQL package.
Curious
Sam
___
Hi List,
Why it is not allowed to write DDL(e.g. create table)
in PL/SQL directly,
but same can be done using DBMS_SQL package.
Curious
Sam
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the
Amy one have any decent stanard error handling packages or link to advice on creating
such a package?
Thanks,
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
Point Energy Corporation
-Original Message-
Sent: Thursday, June 27, 2002 1:04 PM
To: Multiple recipients of list ORACLE-L
I have been building a PL/SQL block to run an 'analyze table validate
structure cascade' against a subset of tables in one schema of our database
(8.1.7 - dail
I have been building a PL/SQL block to run an 'analyze table validate
structure cascade' against a subset of tables in one schema of our database
(8.1.7 - daily backup copy of production). I've initially set this up to
use OPEN_CURSOR . . . PARSE . . . EXECUTE, but was looking fo
you will have to use dynamic sql to do what you want to do.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod
5 Jun 2002, John Weatherman wrote:
> I am in the process of writing a pl/sql block to run on instance A. At
one
> point, I need to run a procedure that resides in instance B against
instance
> B's dataset. Is there an easy way to do this?
>
> The basic problem is:
>
&
John Weatherman wrote:
> I am in the process of writing a pl/sql block to run on instance A. At one
> point, I need to run a procedure that resides in instance B against instance
> B's dataset. Is there an easy way to do this?
>
> The basic problem is:
>
> ### Set up I
I am in the process of writing a pl/sql block to run on instance A. At one
point, I need to run a procedure that resides in instance B against instance
B's dataset. Is there an easy way to do this?
The basic problem is:
### Set up Instance Source for replic
Title: PL/SQL proc calls to a remote DB via DB link
Try
it, you might like it. You might also get your answer quicker than asking
the list.
I
can't find a place where I defined a variable using a remote package but I seem
to remember doing the same type of thing using remote table
Title: PL/SQL proc calls to a remote DB via DB link
If you create a synonym
create myPkgR for user.pkgR@dblinkR;
Then you can use
MyValR MyPkgR.typeR;
This is much cleaner and less confusing ...
Raj
__
Rajendra
Jamadagni
Title: PL/SQL proc calls to a remote DB via DB link
Listers:
You have 2 DBs, "L" local, "R" remote. From within a PL/SQL package or procedure on the *local* DB, is it legal to:
declare a local variable using a *remote* type:
MyVar_L userR.pkgR.typeR@dblinkR;
Hallo,
Anyone who has any good hint on how to write pl/sql if i wantto chang ethe name
of the fields everytime the procedur runs?
The field names should be 1-JULI-2002 the first time the procedur runs, the next time
the procedur runs the name of procedur should be 1-AUG-2002 etc.
Please help
Hi Peter,
Thanks
--- Peter Barnett <[EMAIL PROTECTED]> wrote: > oracle
developer tools users group. www.odtug.com
> maintains a list at fat city.
>
>
> --- Nalla Ravi <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Like this any sqlplus or pl/s
oracle developer tools users group. www.odtug.com
maintains a list at fat city.
--- Nalla Ravi <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Like this any sqlplus or pl/sql message board where
> I
> can clear doubts.
>
> Thanks,
> Ravi
>
> ___
Ganesh Raja [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 2:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Type problems with PL/SQL function as a Java wrapper.
>
>
> Main is a reserved function in Java you cannot use that in your
> programs.
>
>
Hi,
Like this any sqlplus or pl/sql message board where I
can clear doubts.
Thanks,
Ravi
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please se
file into the DB. I
can then create a PL/SQL procedure as a wrapper:
CREATE OR REPLACE PROCEDURE qlp_proc (file_and_parms IN VARCHAR2) AS
LANGUAGE JAVA
NAME 'qlp.main (java.lang.String[])';
/
And it works, but I need to test for success/fail. But if I try a
FUNCTION
wrapper:
CREATE OR R
turn (retval);
}
}
// End of Java code
I run javac to compile it, then loadjava the class file into the DB. I can
then create a PL/SQL procedure as a wrapper:
CREATE OR REPLACE PROCEDURE qlp_proc (file_and_parms IN VARCHAR2)
AS LANGUAGE JAVA
NAME 'qlp.main (java.lang.String[])';
If you're on 8i+ you can use java to get the value.
hth
connor
--- [EMAIL PROTECTED] wrote: > Hi ,
> I want to use a unix shell variable value in
> PL/SQL.
> Is it possible,if yes then how..give example.
>
> for e.g at unix prompt : export inp_val=2000
BDY.RTF
Description: RTF file
You can call them by building a wrapper in the Java in DB and have it call
the external procedure. You can expose that internal Java to the PL/SQL
RTFM and get back with any further queries. The Oracle Java documents have
quite a bit of useful info on this
Cheers
501 - 600 of 1412 matches
Mail list logo