Running Queries in JCAPS

Hi,

According to my knowledge for this type of requirement, u have to write

code as you write for jdbc programs.

That is get database connection, createstatement,executeQuery.

Steps

1)Create user defined OTD for ur inoput query with one field as string.

2) Create OTD using any database wizard[like JDBC or ORACLE].

While creating OTD just select preparedstatements options, at least

u have to select one option from three. Don't give any input for

preapred statement just click next and finally click finish.

3) Create JCD and select database OTD.

4) Write JDBC code like

Connection con = OTD.getConnection().

Statement st = con.createStatement()

int result = st.executeUpdate("query").

There might be other better procedures for your requirement, but i

have posted whatever i know. Hope it will help you in some way.

Regards

Venkatesh.S

VenkateshSampoornam at 2007-7-7 12:04:24 >