Errors in procedure

[israel05]

CREATE PROCEDURE XML
 
/

[marist89]

great, what's the error?

[israel05]

Sorry, I am getting the following errors:

(1): PL/SQL: ORA-00936: missing expression
(2): PL/SQL: SQL Statement ignored
(3): PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following:
(3):
(3): begin case declare else elsif end exit for goto if loop mod
(3): null pragma raise return select update while with
(3):
(3): << close current delete fetch lock insert
(3): open rollback savepoint set sql execute commit forall merge
(3): pipe
(4): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
(4):
(4): end not pragma final instantiable order overriding static
(4): member constructor map

[gandolf989]

I would guess that the error relates to this code:

    SELECT @name (extractvalue(Value(t), @name))
      FROM forms values, table(xmlsequence(cust_keys, ('//starts with (kv)')
       FOR EACH INTO var 1.;

Are you sure that this is even valid? You want an implicit cursor FOR LOOP. Also, when you declare NUMBER variables you should declared the type, i.e. (12,2), or better yet mytable.numbercol%TYPE.

[israel05]

Thank you for your replies. Actually the datatype is xmltype.

No, I am not sure that the code is valid. I am really confused on the this pl/sql stuff. I have tried to read up on it but it just confuses me more.

Please help me!

[stecal]

You're missing BEGIN.

[WilliamR]

The code snippet posted above isn't anything like PL/SQL. What is it? If you don't know PL/SQL you can't just switch to another language.