Doubt with pro*c

[Shivakumar_3]

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.

[Mugilvannan · Accepted solution]

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

[Arunvijai_4]

http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/4446a5b527c3f321/56070a01864b188b%2356070a01864b188b?sa=X&oi=groupsr&start=0&num=3

-Arun