-
Errors in procedure
Code:
CREATE PROCEDURE XML
/
Last edited by israel05; 08-26-2005 at 02:19 PM.
-
-
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
-
I would guess that the error relates to this code:
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.
-
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!
Last edited by israel05; 08-26-2005 at 10:36 AM.
-
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|