I’m not able to reproduce this in v 10.6 +. Here is my test scenario:
Execute the following script to setup the table and insert a row of data:
Create the following procedure and compile via F9 (or F5)
Am I missing anyting?
From: steffen.brosig [mailto:email@example.com]
Sent: Wednesday, October 30, 2013 2:55 AM
Subject: [Toad for Oracle - Discussion Forum] select with xmltable leads to different behavior between F9 and F5, Error in Syntax check ?
select with xmltable leads to different behavior between F9 and F5, Error in Syntax check ?
Thread created by steffen.brosig
In the Create Statement of a procedure we have following code:
SELECT INTO FROM table1, XMLTABLE( myStringVar PASSING …) WHERE …;
If I use F9 to compile it, I get the Message:[Error] Syntax check (519: 26): Found: ‘i_xpath’ Expecting: string -or- XMLNAMESPACES
If I use F5, everything is fine: Procedure created.
We have this in Toad 10.6 and 11.2. (Cannot test toad 12, our procurement management is a bit slow).
Thank’s in anticipation.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.