OCI or OCCI

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

schw - 28 Apr 2006 11:20 GMT

Hi All,

I have a java program and I'd like to call a stored procedure or create
triggers on oracle, can I use OCI for this ?

thanks

best regards
schw

Reply to this Message

Amogh - 28 Apr 2006 14:02 GMT

> Hi All,
>
[quoted text clipped - 5 lines]
> best regards
> schw

>I have a java program and I'd like to call a stored procedure or
>create triggers on oracle

Why not just use JDBC ?

Rgds.
Amogh

Reply to this Message

Jim Kennedy - 28 Apr 2006 15:23 GMT

> Hi All,
>
[quoted text clipped - 5 lines]
> best regards
> schw

Creating triggers are a rare thing. You don't keep creating them, unlike
selecting, updating,deleting, inserting data. So for creating triggers use
SQLPlus. For Java I would use JDBC to connect to the database.
Jim

Reply to this Message

schw - 28 Apr 2006 15:51 GMT

you're right...but I need a tool that will update them every now and
then..

do you still think using JDBC than OCI ?

Reply to this Message

Amogh - 28 Apr 2006 16:19 GMT

> you're right...but I need a tool that will update them every now and
> then..
>
> do you still think using JDBC than OCI ?

Writing Java, its natural for somebody to use JDBC
to interface with Oracle. Since all you want to do is
create triggers and execute stored procedures, go for JDBC.

Rgds.
Amogh

Reply to this Message

Jim Kennedy - 29 Apr 2006 15:19 GMT

> you're right...but I need a tool that will update them every now and
> then..
>
> do you still think using JDBC than OCI ?

Oracle ships with the tool. It is called sqlplus. Most people writing in
Java use JDBC to access databases.
Jim

Reply to this Message