I have a Null driver that I want to write information to a oracle db
when an add happens. I have another oracle JDBC driver running and have
the correct jar file installed. Using Embedded SQL Statements, how do I
make a connection to the database. Where do I store the connection
string, userid and password, before I add the actions...I have this from
a MSSQL database that the 'other' guy wrote...I would be able to modify
this for oracle, but need help in making the initial connetion....

<do-append-xml-element expression=".." name="jdbc:statement"/>
<do-append-xml-element expression="../jdbc:statement[last()]"
<do-append-xml-text expression="../jdbc:statement[last()]/jdbc:sql">
<token-text xml:space="preserve">UPDATE RBS_DRIVER_MASTER SET
Department ='</token-text>
<token-local-variable name="eDept"/>
<token-text xml:space="preserve">', Title = '</token-text>
<token-local-variable name="eTitle"/>
<token-text xml:space="preserve">' WHERE GLMCJOBCODE =
<token-local-variable name="njobcode"/>
<token-text xml:space="preserve">'</token-text>


rjreisbi's Profile: http://forums.novell.com/member.php?userid=2009
View this thread: http://forums.novell.com/showthread.php?t=362443