This discussion is archived
7 Replies Latest reply: Mar 19, 2010 8:53 AM by 761304 RSS

PLS-00103: Encountered the symbol “end-of-file” when expecting one of the..

761304 Newbie
Currently Being Moderated
Can not run following SQL from ant's sql task:

BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE(
queue_table => 'MY_QUEUE',
queue_payload_type => 'sys.aq$_jms_map_message');

DBMS_AQADM.CREATE_QUEUE(
queue_name => 'MY_QUEUE',
queue_table => 'MY_QUEUE');

DBMS_AQADM.START_QUEUE (
queue_name => 'MY_QUEUE');

END;
/


There are following errror:

CreateMyQueue:
[sql] Executing resource: /u1/bin/sql/createMyQueue.sql
[sql] Failed to execute: BEGIN DBMS_AQADM.CREATE_QUEUE_TABLE( queue_table => 'MY_QUEUE', queue_payload_type => 'sys.aq\$_jms_map_message')

BUILD FAILED
/u1/bin/.tools/build.xml:194: java.sql.SQLException: ORA-06550: line 1, column 118:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
:= . ( % ;


What is wrong with SQL?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points