Need help - how to select data from table

[john9]

Need to understand if the SQL code I created shown below is correct.

A Java application is calling a Oracle 9i stored procedure to retrieve existing XML documents stored in a table.

The Java application will send key fields (named: NODEID, DOCTYPE, and DOCREF). I will then used these fields to select a desired table entry. Once the match is made I then select my XML document column (named: XMLDOC) and send it back to the calling JAVA application.

I would appreciate it if someone can give me some direction if this code looks correct.

Thank You.
-----------------------------------------------------
CREATE OR REPLACE PROCEDURE PRISM.Sp_Ins_Xmldoc(NODEID IN VARCHAR2, DOCTYPE IN VARCHAR2, DOCREF IN VARCHAR2,
xmldata OUT SYS.XMLTYPE)

AS
BEGIN

select XMLDOC from NODALXML X
where X.nodeid = nodeid
and X.doctype = doctype
and X.docref = docref

into xmldata

 

[SantaMufasa]

John,

It is close. Following the "BEGIN", your code should read:

...
select XMLDOC [b]into xmldata[/b] from NODALXML X 
where X.nodeid = nodeid
and X.doctype = doctype
and X.docref = docref;
end;
/

Mufasa
(aka Dave of Sandy, Utah, USA @ 06:44 (02Sep04) UTC (aka "GMT" and "Zulu"), 23:44 (01Sep04) Mountain Time)