Home » Developer & Programmer » Precompilers, OCI & OCCI » help pro*c variable declarations (oracle 8.1.7.4.0 hp ux)
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
..... ..... ..
.... .... ..
... ... ..
Previous Topic: pb pro*c demo_proc.mk
Next Topic: Urgent query - How to pass an array of strings to, and return a table set from a proc
Goto Forum:
  


Current Time: Thu Mar 28 11:18:04 CDT 2024