Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following

610 pts.
Tags:
Oracle development
Oracle SQL
PL/SQL
PL/SQL error messages
PLS-00103
I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following: := . ) , @ % default character The symbol "," was substituted for "OUT" to continue. Can someone help me on this ??

Answer Wiki

Thanks. We'll let you know when a new response is added.

Could you please paste here (discuss section) your code ?
We need to look at it in order to be able to help.

Your database version would be useful as well.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Balajidev
    Want to know the solution for the same as i too face same sort of issue
    10 pointsBadges:
    report
  • carlosdl
    Balajidev, if you have the same problem, then the same answer applies. There is no way we can provide a solution without looking at the code.
    67,785 pointsBadges:
    report
  • Bobf
    I am attempting to copy a Blob from one database to another and I get the following error/ SQL> Declare 2 tpsr Blob; 3 spsr blob; 4 Begin 5 Select '8502' into tpsr from ca90joetmp.spec_form_psr where spec_form_id = '90710'; 6 Select '8502' into tpsr from specdev_mst.spec_form_psr where spec_form_id = '29401'; 7 DBMS_LOB.COPY ( 8 tpsr IN OUT NOCOPY BLOB, 9 spsr IN BLOB, 10 amount IN INTEGER, 11 dest_offset IN INTEGER := 1, 12 src_offset IN INTEGER := 1); 13 end; 14 / tpsr IN OUT NOCOPY BLOB, * ERROR at line 8: ORA-06550: line 8, column 15: PLS-00103: Encountered the symbol "OUT" when expecting one of the following: (
    15 pointsBadges:
    report
  • carlosdl
    Hi Bobf. You use the IN, OUT and NOCOPY keywords when declaring a procedure, not when calling it. In your case, the call to dbms_lob.copy should be something like this:
    dbms_lob.copy(tpsr,spsr,amount,dest_offset,src_offset);
    But if you are going to use the default values (1) for dest_offset and src_offset, this would suffice:
    dbms_lob.copy(tpsr,spsr,amount);
    If the variables being passed to the procedure are not declared or contain invalid values you will get more errors.
    67,785 pointsBadges:
    report
  • RAM13INDIAN
    IN THIS PROCEDURE IAM GETTING ERR MSG THAT"ENCOUNTERED THE SYMBOL "DECLARE" WHEN EXPECTING ONE OF THE FOLLOWING:" BUT IAM USED THE DECLARE STATEMENT WITH ; AND WITHOUT ; BUT IAM GETTING SAME ERR MSG create or replace procedure t5 as declare no1=1; while(no1<500) begin print no1 no1:=no1+1 if no1=500 EXIT; end;
    10 pointsBadges:
    report
  • carlosdl
    RAM13INDIAN, you code has many errors. I think you need to search the web for the basics on PL/SQL before trying to write a procedure. Also, if you need help, please create a new question, so your problem gets the attention it deserves.
    67,785 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following