I'd like to use ExecProc

[Dym]

I don't understand how use TOraSession::ExecProc in CBuilder.
This code doesn't work:

Code: Select all

Variant vPar[1];
vPar[0] = 11;
OraSession1->ExecProc("GET_MAIN_TREE_NODE_SQL", vPar, 0);

Stored procedure:

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;  

Does anybody know where is problem?

[Alex]

We cannot reproduce your problem. We need more detailed description i.e. your Oracle client/server versions, ODAC version, complete sample to demonstrate your problem and script to create server objects.
Please, send a message to our ODAC support e-mail address.