Home » Developer & Programmer » Precompilers, OCI & OCCI » OCI
OCI [message #157053] Tue, 31 January 2006 01:31 Go to next message
anvitha
Messages: 2
Registered: January 2006
Junior Member
can i insert the values through OCIBindByName

[Updated on: Tue, 31 January 2006 01:40]

Report message to a moderator

Re: OCI [message #167282 is a reply to message #157053] Wed, 12 April 2006 04:25 Go to previous message
Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...
Senior Member

Hi

Yes. You bind your memory structures to SQL place holders

eg
INSERT INTO emp VALUES
(:empno, :ename, :job, :sal, :deptno)

bindbyname(...":empno"...)
bindbyname(...":ename"...)
bindbyname(...":job"...)
bindbyname(...":job"...)
bindbyname(...":sal"...)
bindbyname(...":deptno"...)
etc

Kind regards
Michael Hartley
http://www.openfieldsolutions.co.uk
Previous Topic: Newbie problem with versions and compatibility
Next Topic: 'ORA-03123 - operation would block
Goto Forum:
  


Current Time: Thu Mar 28 05:40:49 CDT 2024