| help pro*c variable declarations [message #490005] |
Thu, 20 January 2011 10:05 |
 |
9390512774
Messages: 103
Registered: January 2011
Location: hyd
|
Senior Member |
|
|
i have a code below
EXEC SQL EXECUTE
BEGIN
:ln_status := uf_bomexplosion(:Num_org_mfg,:Num_rsrc,1,'Y',<OUT mode variable>,FALSE,TRUE);
END;
END-EXEC;
fprintf(outputfile,"%s%s%s%s",<variables list.....>);
the type of out mode variable in the above PLSQL FUNCTION is defined in below type datatype
TYPE t_rsrcRecord IS RECORD (
an_rsrc char(10),
an_qty char(20),
ac_flag float
);
TYPE Vt_comprecord IS TABLE OF t_rsrcRecord INDEX BY BINARY_INTEGER;
I want to write the data avialable in OUT mode variable in plsql function defined above into flatfile in c.
please provide me the which type of host varible i have to declare in Pro*c.
that is supporting plsql table type returning 3 columns and unknow no of rows (0 to any no of rows).
example the follwing data is in out mode varaible in plsql function.
.................
abc raja 1
ksdj dsls 2
jfsl ldss 0
dsjf dkfslfd 7
..... ..... ..
.... .... ..
... ... ..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
