HELP:Oraperl and Stored Procedure 
Author Message
 HELP:Oraperl and Stored Procedure

Hi there,

I'm using oraperl to access a Oracle DB v.7.1.6 on a Sun Sparc station
20.

In that case I'm having trouble calling a stored procedure, having nine
input parameters and three output parameters. When I call this
procedure, called auto_reg, the procedure fail. Then I'm having trouble
finding out what's wrong. The ora_errstr value is:
        ORA-06550: line , column :
and the ora_errno value is:
        ora_errno=-6550

How do you get the value of "RAISE"-errors from the procedure ??

BTW: I have been trying to use out parameters in a stored procedure
using ODBC, and been told that it dosen't work with ODBC. Now I'm
wondering if that's the same using oraperl (I know that oraperl dosen't
use ODBC).

Please email me, and I will tell the "world" the answer.

Thanks in advance.
--

************************************************************************
*                    ()_/         Morten Kristiansen                   *
*            ____    /|           Tele 3 Norge AS                      *

*\_                ._\__\_,       Phone: +47 2291 9015                 *
*..\          __                  Fax  : +47 2291 9100                 *
*...\________/..\                                                      *
************************************************************************



Thu, 13 May 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. oraperl & stored procedures

2. Oraperl - Stored Procedures How to ??

3. Oraperl - executing stored procedures

4. Oraperl and stored procedures

5. Can Oraperl call Oracle stored procedures?

6. oraperl and stored procedures

7. Someone please post Oraperl calling Oracle Store procedure example(s)

8. OraPerl and PL/SQL Stored Procedure

9. Oraperl - Stored Procedures How to ??

10. ORAPERL: How can I get an output paramater from an Oracle Stored Procedure

11. Stored Procedures using Oraperl

12. Wanted to know: Oracle stored procedures in oraperl?

 

 
Powered by phpBB® Forum Software