I'd like to use ExecProc
Posted: Wed 09 Nov 2005 12:45
I don't understand how use TOraSession::ExecProc in CBuilder.
This code doesn't work:
Stored procedure:
Does anybody know where is problem?
This code doesn't work:
Code: Select all
Variant vPar[1];
vPar[0] = 11;
OraSession1->ExecProc("GET_MAIN_TREE_NODE_SQL", vPar, 0);
Code: Select all
function GET_MAIN_TREE_NODE_SQL(rootid in number) return clob
is
retVal clob;
begin
select META_TREE."SQL"
into retVal
from META_TREE
where META_TREE.ROOT_ID = rootid;
return retVal;
end;