var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Returning recordset from oracle to VB
Well I had encountered with this problem, as I want to return a no. of rows as a recordset from an Oracle procedure and want to open that as a recordset in VB. I had tried this...
create or replace PACKAGE PackPerson
TYPE tbl_dt IS TABLE of date
INDEX BY BINARY_INTEGER;
PROCEDURE Getserverdate3 (dtCurr OUT tbl_dt);
create or replace Package Body PACKPERSON
PROCEDURE Getserverdate3 (dtCurr OUT tbl_dt)
CURSOR c1 IS
percount number default 1;
FOR c in c1 LOOP
dtCurr(percount) := c.sysdate;
percount := percount + 1;
and in VB I had opened this as ......
Dim rsgetDate As ADODB.Recordset
Set rsgetDate = New ADODB.Recordset
rsgetDate.Open "exec Getserverdate3 ", mycon, 3, 3
but on executing got this error:
ORA-00900: Invalid SQL statement..
Thanking u in anticipation.