Pls-00363 Expression Cannot Be Used As An Assignment Target Online

When I'm Trying to connect with Oracle Stored Procedure and getting the Following Error:

My Stored Procedure is declared like the Following :

PROCEDURE spSearchBCLClaimsArchive

    (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?

NOTE:

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

 

0 thoughts on “Pls-00363 Expression Cannot Be Used As An Assignment Target Online

Leave a Reply

Your email address will not be published. Required fields are marked *