I have the following named query for an Oracle database. When it is
run I get the error "Not all named parameters have been set". I think
it could be the : characters used in the assignment but am not sure.
Can these characters be escaped?
<sql-query name="BulkApplyXA.Oracle">
<return-scalar column="ReturnValue" type="Int32" />
<return-scalar column="TotalXAProcessed" type="Int32" />
<return-scalar column="ErrorMessage" type="String" />
DECLARE
V_POCOUNT NUMBER;
V_POERROR VARCHAR2(32767);
V_PORETURNVALUE NUMBER;
V_CURSOR SYS_REFCURSOR;
BEGIN
V_POCOUNT := NULL;
V_POERROR := NULL;
V_PORETURNVALUE := NULL;
DBO.MYPROC ( V_POCOUNT, V_POERROR, V_PORETURNVALUE );
OPEN V_CURSOR FOR
SELECT V_PORETURNVALUE AS ReturnValue, V_POCOUNT AS
TotalXAProcessed, V_POERROR AS ErrorMessage from dual;
END;
</sql-query>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
