Doubt with pro*c

 
SOLVED
Go to solution
Shivakumar_3
Advisor

Doubt with pro*c

Hello everybody,
Is there any method to access shared memory using pro*c.Actually i am storing a packet
(buffer) of 512kb in shared memory and i want to directly put that buffer into database using pro*c.How can i go about it.Please help me out.Thanks in advance.
2 REPLIES 2
Mugilvannan
Valued Contributor
Solution

Re: Doubt with pro*c

You can override the default assignments by equivalencing host variables to Oracle8 external datatypes, using the EXEC SQL VAR statement. This is called host variable equivalencing.

The EXEC SQL VAR statement can have an optional clause: CONVBUFSZ (). You specify the size, , in bytes, of the buffer in the Oracle8 runtime library used to perform conversion of the specified host variable between character sets.

The new syntax is:

EXEC SQL VAR is [CONVBUFSZ [IS] ()] ;


or

EXEC SQL VAR [cONVBUFSZ [IS] ()];


where is:

[ ( { | , } ) ]

Also refer, http://otn.oracle.com/software/ tech/migration/toolkits/zim/zimwp.pdf
If U need a helping hand, U will find one at the end of your arm
Arunvijai_4
Honored Contributor

Re: Doubt with pro*c