INOUT issue

Training
N/A

INOUT issue

 

CALL sp_xml_preparedocument (v_DocHandle INOUT, v_XmlDocument);

 

select * from OPENXML (v_DocHandle ,"/ArrayOfPair/Pair",2)

with("Key" VARCHAR(255),"Value" VARCHAR(255));

 

CALL sp_xml_removedocument(v_DocHandle);

I have two unsolved issues in my code- mentioned by red. Does anybody know what wrong with it?

 

TNX

 

 

 

 

END;

2 REPLIES
N/A

Re: INOUT issue

And what is your actual issue, syntax errors?

 

You try to run SQL Server syntax in Teradata, of course this fails, there are no functions named sp_xml_preparedocument or OPENXML.

Additionally the calling convention is wrong, there's no INOUT parameter in a CALL and strings are single quoted.

N/A

Re: INOUT issue

Thank you very much, i'm new in Teradata... tnx a lot!