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

0
7 comments
Avatar
Joseph Hamdan

Hi Hicham,

Thanks for posting on our forum. We are still working on debugging this issue and will be posting updates soon.

We appreciate your patience.

Regards,

Subject7 Team

0
Comment actions Permalink
Avatar
Jonathan Hotz

Hi Hicham,

could you please try actions below to solve it and provide us your results?

  1. 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.
  2. Try to use more simple string values to test if your query works.
  3. Try to use space in the end of each line.
0
Comment actions Permalink
Avatar
Hicham Tahiri

I tried that but got the same error. It seems like executing a sql procedure is not working. Can you send a dummy procedure example to try on.

0
Comment actions Permalink
Avatar
Jonathan Hotz

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?

0
Comment actions Permalink
Avatar
Hicham Tahiri

I am aware of that. I tried removing the semicolon in the end and still got the same error. I tried both Execute_sql & Get_Db_Value command. Both with same error

0
Comment actions Permalink
Avatar
Rex Feizi

I have 2 questions: 

1. Does the below stored procedure work on your SQL Developer? 

2. If yes, does it work in Subject7? 

So are you saying you have tried a simple procedure like:

BEGIN
  
  DBMS_OUTPUT.PUT_LINE('Hello World!');

END



0
Comment actions Permalink
Avatar
Hicham Tahiri

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

0
Comment actions Permalink

Please sign in to leave a comment.