------_=_NextPart_001_01C7026C.D258B9BF
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi,

I am trying to execute the stored procedure using dbh. The procedure=
details are as follows:
proc_dequeue( BALID,strRequestXML,strStatus)

where:
BALID - Integer,
strRequestXML - XMLType,
strStatus - varchar

The perl script implemented is :

my $sth =3D $dbh1->prepare("begin=
proc_dequeue(:BALID,:strRequestXML,:strStatus); end;");

$sth->bind_param_inout(":BALID",\$o_balid,20,\%attr );
$sth->bind_param_inout(":strRequestXML",\$o_requestXML,50000 ,\%attr);
$sth->bind_param_inout(":strStatus",\$o_status,2,\%attr);

and the error message i am getting is :

DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'proc_dequeue'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute) at ./ListenerBalA=
line 32.
DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'proc_dequeue'

Please help me to resolve this problem.

Thanks in advance.

Regards,
Sumitra







=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D

Tech Mahindra, formerly Mahindra-British Telecom.

Disclaimer:

This message and the information contained herein is proprietary and=
confidential and subject to the Tech Mahindra policy statement, you may=
review at <a href=
=3D"http://www.techmahindra.com/Disclaimer.html">http://www. techmahindra.co=
m/Disclaimer.html</a> externally and <a href=
=3D"http://tim.techmahindra.com/Disclaimer.html">http://tim. techmahindra.co=
m/Disclaimer.html</a> internally within Tech Mahindra.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D
------_=_NextPart_001_01C7026C.D258B9BF--

Sumitra Gatade wrote:
> Hi,
>
> I am trying to execute the stored procedure using dbh. The procedure
> details are as follows:
> proc_dequeue( BALID,strRequestXML,strStatus)
>
> where:
> BALID - Integer,
> strRequestXML - XMLType,
> strStatus - varchar
>
> The perl script implemented is :
>
> my $sth =3D $dbh1->prepare("begin
> proc_dequeue(:BALID,:strRequestXML,:strStatus); end;");
>
> $sth->bind_param_inout(":BALID",\$o_balid,20,\%attr );
> $sth->bind_param_inout(":strRequestXML",\$o_requestXML,50000 ,\%attr);
> $sth->bind_param_inout(":strStatus",\$o_status,2,\%attr);
>
> and the error message i am getting is :
>
> DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to
> 'proc_dequeue'

You are passing a string to a function that expects XMLType, an opaque
Oracle object type. The XMLType API provides a constructor that takes a
varchar2 argument, so try changing your statement to:

begin proc_dequeue(:BALID,XMLType(:strRequestXML),:strStatus); end;

Regards,
Philip

This is not a DBI or a perl issue.

Read your error stack and resolve your Oracle issue.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Sumitra Gatade [mailto:sumitrag [at] TechMahindra.com]
Sent: Tuesday, November 07, 2006 6:01 AM
To: dbi-users [at] perl.org
Subject: DBI - error


Hi,

I am trying to execute the stored procedure using dbh. The procedure
details are as follows:
proc_dequeue( BALID,strRequestXML,strStatus)

where:
BALID - Integer,
strRequestXML - XMLType,
strStatus - varchar

The perl script implemented is :

my $sth =3D $dbh1->prepare("begin
proc_dequeue(:BALID,:strRequestXML,:strStatus); end;");

$sth->bind_param_inout(":BALID",\$o_balid,20,\%attr );
$sth->bind_param_inout(":strRequestXML",\$o_requestXML,50000 ,\%attr);
$sth->bind_param_inout(":strStatus",\$o_status,2,\%attr);

and the error message i am getting is :

DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'proc_dequeue'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute) at ./ListenerBalA
line 32.
DBD::Oracle::st execute failed: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'proc_dequeue'

Please help me to resolve this problem.

Thanks in advance.

Regards,
Sumitra







=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D

Tech Mahindra, formerly Mahindra-British Telecom.

Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at <a
href=3D"http://www.techmahindra.com/Disclaimer.html">http:// www.techmahin=
d
ra.com/Disclaimer.html</a> externally and <a
href=3D"http://tim.techmahindra.com/Disclaimer.html">http:// tim.techmahin=
d
ra.com/Disclaimer.html</a> internally within Tech Mahindra.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=
=3D=3D

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended
to be for the use of the individual or entity named above. If you are =
not the
intended recipient, please be aware that any disclosure, copying, =
distribution
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.