Skip to Content
0
Former Member
Jul 03, 2007 at 11:00 AM

BO v5.1 - creating a report from an oracle stored procedure

13 Views

Post Author: newrochelle

CA Forum: Publishing

hi to all,

im using BO 5.1 and i need to create a document from an oracle stored procedure that have only one IN parameter and ten OUT parameters.

Creating the new report I selected the database connection then I choose the stored procedure name from the list, I inserted the value for the IN parameter and finally I click on Run button.

I got the following error message:

ORA-06550: line 1, column 38: :PLS-00103: Encountered the symbol

"," when expecting one of the following: : : ( - + case mod

new not null others <an identifier> : <a double-quoted

delimited-identifier> <a bind variable> avg : count current

exists max min prior sql stddev sum variance : execute forall

merge time timestamp interval date : <a string literal with

character set specification> : <a number> <a single-quoted SQL

string> pipe : <an alternatively-quoted string literal with

character set specification> : <an alternatively-q :-6550

it seems to be caused by the OUT parameters!

i leaved them without any value.

it's the first time that I used a stored procedure to create a BO report, but I think the OUT parameters are needed to do that, otherwise what data will be presented in the report???

can you help me?

please answear me ASAP.

Thank's in advance

Regards

Andrea