How to run a sql procedure in Proof
I tried running a procedure using Execute_Sql command : test_proc
begin
message_bus_support_pkg.post_message('PROJECT_SEGMENT_APP','<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<segmentsEvents xmlns="http://era.nih.gov/projp/segmentsEvents-V1.0">
<applId>555555</applId>
<action>APPL_GRANT_NUM_UPDATED</action>
<applClassCode>G</applClassCode>
</segmentsEvents>', '1.0', 'PROJP') ;
commit;
end;
But I get this error:
error occurred during batching: ORA-06550: line 1, column 338:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
:= . ( % ;
the database version and vendor:
pl/sql developer
version 12.0.7.1837
Hi Hicham,
could you please try actions below to solve it and provide us your results?
- Try to copy and paste your query line by line from the editor you used before. It can happen that you paste invisible symbols when you copy full text.
- Try to use more simple string values to test if your query works.
- Try to use space in the end of each line.
Your query with procedure call looks simple enough. Just one note: Oracle SQL queries should not be finished with semicolon [ ; ].
Oracle SQL Developer removes semicolon in the end of query automatically, but we don't do it. Could you please try to use your query without semicolon in the end?
1- the stored proc doesn't work in SQL developer. I have to add ; at the end to make it work.
error: PLS-00103: Encountred the symbol "end-of-file" when expecting one of the following: ; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
Same error using Oracle SQL developer. ";" is required at the end.
2- the stored proc doesn't work in Subject7. Also when adding the ; at the end , I get the same mentioned error
Please sign in to leave a comment.