oo4o and plsql [message #10088] |
Fri, 02 January 2004 17:07 |
smile
Messages: 3 Registered: January 2004
|
Junior Member |
|
|
i have made a package in oracle,using RECORD type as parameter in package's interface.now code is like under.
CREATE OR REPLACE PACKAGE test IS
TYPE UpdDataRec IS RECORD (
SyoriKbn CHAR
,YykDelFuyoFlg NUMBER
,CdyKanriFuyoFlg NUMBER
,YoyakuNo RSTT_GOLFTIMBET_LC.YoyakuNo%TYPE
,RiyoDat RSTT_GOLFTIMBET_LC.RiyoDat%TYPE
,CourseKbn RSTT_GOLFTIMBET_LC.CourseKbn%TYPE);
TYPE UpdDataTbl IS TABLE OF UpdDataRec INDEX BY BINARY_INTEGER;
PROCEDURE MAIN (
pn_Ret OUT NUMBER
,pa_UpdData IN UpdDataTbl);
END;
i want use this package in oo4o(vb),
but i dont't know how to use it;
please help me ,thank you very much.
|
|
|
Re: oo4o and plsql [message #10090 is a reply to message #10088] |
Sun, 04 January 2004 22:55 |
Daljit Singh
Messages: 290 Registered: October 2003 Location: Texas
|
Senior Member |
|
|
Hi Smile,
Nice Name.
Well if u want to access this package in ur VB prog then u should specify packagename.pocedurename to access any proc/function described in ur package. But to access any global variable declare in ur package u have to create an interface. I mean u cant access package's variables directly from VB for that just create function to return the values of package variables or use procedure with out parametes.
And the types which u have declared in ur package can only be accessible within package. All the manipulations will be in package from VB u have pass the values for that manipulation and after that u can get output from ur proc/func using return or out parameters.
I hope it will help u.
|
|
|