How to call oracle procedure in impromptu report

[Polavarapu]

Hi,
I am using Oracle Stored Procedure as a data source in my
impromptu report.In my procedure 1 input and 1 output
is there.So how can I call that procedure in my report
Thank you.

 

[griffindm]

See faq401-907. It's a copy of a Cognos knowledgebase article on this topic.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[Polavarapu]

Hi,
Thank You for your reply.
In impromptu i am giving like this
call TEST_PROC1(?i_PROD_ITEM_MODEL_NUMBER? IN)


Error number -9:

DMS-E-GENERAL, A general exception has occurred during operation 'execute'.
ORA-06550: line 1, column 7:
PLS-00201: identifier 'TEST_PROC1' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Note:- I have 1 input and 1 output.So how can i declare
the output parameter.

Please give me the solution.

Thank You

 

[griffindm]

I don't use this option much, but when I do, I've found that for Oracle I have to use the syntax:

Begin sp_name(param1,param2,...); End;

in order to get it to work. This was for version 7. Try it and let me know if it works for you.

Regards,

Dave Griffin




The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com