topic Doubt with pro*c in Operating System - Linux

Doubt with pro*c

Shivakumar_3 — Sun, 09 Oct 2005 23:21:23 GMT

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.

Re: Doubt with pro*c

Mugilvannan — Sun, 09 Oct 2005 23:27:20 GMT

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

Re: Doubt with pro*c

Arunvijai_4 — Sun, 09 Oct 2005 23:31:18 GMT

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

-Arun