When I'm Trying to connect with Oracle Stored Procedure and getting the Following Error:
My Stored Procedure is declared like the Following :
(picClaimNumber IN CLOB ,
pivUserName IN VARCHAR2,
pivFileName IN VARCHAR2,
povStatus OUT VARCHAR2,
povErrorMessage OUT VARCHAR2,
pioProcessID IN NUMBER,
poRefCurResults OUT SYS_REFCURSOR) IS
The Stored Procedure is running successfully in the back-end:
According to my understanding ORA-06550 Error most Probably comes due to wrong combination of "IN","OUT" and "IN OUT" parameters of Stored Procedure. Can anyone tell me the right set of parameters to use for Crystal Reports. Please correct me if i am wrong?
1. I Tried with various Connections like OLE DB,ORACLE SERVER (Native Oracle)
2. I used CLOB in Stored Procedure to display up-to 200 Claim numbers. - Will it Work in Crystal Reports 2011
IT would be great if anyone provide any document link about the "limitationsof Crystal Reports 2011"- Especially with Oracle Stored Procedure
Burleson is the American Team
Note:This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum.
Verify experience!Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.
Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail:
and include the URL for the page.
Copyright © 1996 - 2017
All rights reserved by Burleson
Oracle® is the registered trademark of Oracle Corporation.
Remote Emergency Support provided by Conversational