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

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


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