Toad World® Forums

AW: select with xmltable leads to different behavior between F9 and F5, Error in Syntax check ?


#1

Hi Gregory,
I have to correct myself: only 10.6 is affected. My workmate made a test with 11.0.0 - no problems.
The difference between my code and your test is: I use a variable (myStringVar, in origin: i_xpath) to transfer the X-path to function XMLTABLE.
kind regards
Steffen
-----Ursprüngliche Nachricht-----
Von: Gregory Liss [mailto:bounce-GTDG@toadworld.com] Gesendet: Mittwoch, 30. Oktober 2013 12:44
An: toadoracle@toadworld.com
Betreff: RE: [Toad for Oracle - Discussion Forum] select with xmltable leads to different behavior between F9 and F5, Error in Syntax check ?
RE: select with xmltable leads to different behavior between F9 and F5, Error in Syntax check ? Reply by Gregory Liss 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 table xmljunk (id number, profile xmltype);
insert into xmljunk values (1, XMLTYPE(’
I
like
sports
music
‘));
commit;
Create the following procedure and compile via F9 (or F5)
CREATE OR REPLACE PROCEDURE xmltest
IS
i_xpath varchar2(4000);
BEGIN
select x.object.getStringVal() into i_xpath
from xmljunk u,
XMLTABLE(’/profile/subject/action’
passing u.profile
columns action VARCHAR2(30) PATH ‘text()’,
object XMLTYPE PATH ‘object’) x;
end;
Am I missing anyting?
From: steffen.brosig [mailto:bounce-steffenbrosig@toadworld.com] Sent: Wednesday, October 30, 2013 2:55 AM
To: toadoracle@toadworld.com
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.
Steffen
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether. Toad for Oracle - Discussion Forum Flag this post as spam/abuse. To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether. Toad for Oracle - Discussion Forum Flag this post as spam/abuse.