Hi, I'm calling an external Stored Procedure written in PL/SQL that
includes one input argument and an output argument that is a REF
CURSOR.
When I run the code I get the error's indicated below. Any ideas on
what
needs to be changed?
If it is a procedure (as opposed to a function), it does not h
Not sure why you what the stored procedure looks like, but why are you using
the ref cursor both as a parameter and a return value? If it was a
procedure you would just have it an an IN OUT parameter, with just
"BEGIN Package.Pr_Get_Config_System_Path(:p1,:out_cursor); END;"
and vice versa if i
>
> On Thu, Apr 14, 2005 at 07:50:43AM -0400, Jeff Urlwin wrote:
> > > >
> > > > I would write as:
> > > > $dt = "#04-MAY-2004 17:03:34#";
> > >
> > > Wouldn't single quotes also work?:
> > >
> > > $dt = "'04-MAY-2004 17:03:34'";
> > >
> > > > Converting the month to a 3-character string ver
Tim Bunce wrote:
>On Thu, Apr 14, 2005 at 09:19:00AM +1000, Daniel Kasak wrote:
>
>
>>Robb wrote:
>>
>>
>>
>>>Hi,
>>>
>>>Does anyone have any idea what is up with Microsoft Access and its
>>>ridiculous Date/Time formatting options?
>>>
>>>
>>:)
>>
>>In VB, I use the format:
>>
>>#dd-mm
What people have been saying in this thread is that you should seriously
consider using the placeholder/bind feature of DBI when you insert rows. If
you don't know the feature, learn it in the Perl doc. You'll write less code.
Let me try to explain this simply: when you use this feature, you d
This is most likely not a DBI issue. Check metalink note 27323.1.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Denesa K Shaw [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 1:02 PM
To: dbi-users@perl.org
Subject: Calling Stored Procedure u
And, as pointed out, you should be using bind variables (see bind_param) for
this type of operation.
For instance, given a valid connect to Oracle:
$sth_o = $dbh_ora->qq{
select col1, col2, col3
from table1
where col4=:val
}) || die $dbh_ora->errstr;
while()
{
$sth_o->bind_param(':val',
Hi, I'm calling an external Stored Procedure written in PL/SQL that
includes one input argument and an output argument that is a REF CURSOR.
When I run the code I get the error's indicated below. Any ideas on what
needs to be changed?
Package Information:
p1-Procedures input argument (VARCHAR
Hi ,
Thanks for replying.
My problem is, the perl script successfully gets rows from oracle database
but I have to insert it into similar table in db2 i.e( x in oracle -> x in
db2) . For this I need to know the datatypes of columns (varchar, char,date
,timestamp) as these need quotes for insertio
Assuming you have a group of rcds called tth;
$nbrFlds = $tth->{NUM_OF_FIELDS}; ### returns the # of fields
for ($ixx=0; $ixx < $nbrFlds ; $ixx++) {
$xname = $tth->{NAME}->[$ixx]; ### returns the field name
}
Caveat,
This might be dependent on the drivers you use;
Quoting Vamsi_Doddapaneni <[EMAIL PROTECTED]>:
> I am new to perl just (1 1/2 month experience.). I am developing perl script
> which connects to oracle database and selects rows from a (x) table and then
> inserts them into its corresponding table in db2. So, while inserting i need
> to find what
On 4/14/05, Darren Duncan <[EMAIL PROTECTED]> wrote:
> At 7:38 PM +0530 4/14/05, Vamsi_Doddapaneni wrote:
> >Hi all
> >I am new to perl just (1 1/2 month experience.). I am developing perl script
> >which connects to oracle database and selects rows from a (x) table and then
>
> A simple generic s
Have you looked at type_info_all()? It may provide what you need, but I
recommend using bind parameters instead.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Vamsi_Doddapaneni [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 8:09 AM
To: db
At 7:38 PM +0530 4/14/05, Vamsi_Doddapaneni wrote:
Hi all
I am new to perl just (1 1/2 month experience.). I am developing perl script
which connects to oracle database and selects rows from a (x) table and then
inserts them into its corresponding table in db2. So, while inserting i need
to find wh
On Thu, Apr 14, 2005 at 07:50:43AM -0400, Jeff Urlwin wrote:
> > >
> > > I would write as:
> > > $dt = "#04-MAY-2004 17:03:34#";
> >
> > Wouldn't single quotes also work?:
> >
> > $dt = "'04-MAY-2004 17:03:34'";
> >
> > > Converting the month to a 3-character string version forces
> > Access
Hi all
I am new to perl just (1 1/2 month experience.). I am developing perl script
which connects to oracle database and selects rows from a (x) table and then
inserts them into its corresponding table in db2. So, while inserting i need
to find what is the datatype of columns , since we need to u
I just answered this a day or two ago. Please use 24.249.249.7 as the IP
instead of
ftp.esoftmatic.com until I get my ISP to respond to the DNS needs.
Thanks,
Jeff
> -Original Message-
> From: Ramesh Patel [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 13, 2005 1:33 PM
> To: db
>
>
> On Thu, Apr 14, 2005 at 09:19:00AM +1000, Daniel Kasak wrote:
> > Robb wrote:
> >
> > > Hi,
> > >
> > > Does anyone have any idea what is up with Microsoft
> Access and its
> > > ridiculous Date/Time formatting options?
> >
> > :)
> >
> > In VB, I use the format:
> >
> > #dd-mmm-
On Thu, Apr 14, 2005 at 09:19:00AM +1000, Daniel Kasak wrote:
> Robb wrote:
>
> > Hi,
> >
> > Does anyone have any idea what is up with Microsoft Access and its
> > ridiculous Date/Time formatting options?
>
> :)
>
> In VB, I use the format:
>
> #dd-mmm- HH:mm:ss#
>
> Your example:
> $dt =
19 matches
Mail list logo