dbTalk Databases Forums  

OCI or OCCI

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc OCI or OCCI

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss OCI or OCCI in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
schw
 
Posts: n/a

Default OCI or OCCI - 04-28-2006 , 05:20 AM





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 With Quote
  #2  
Old   
Amogh
 
Posts: n/a

Default Re: OCI or OCCI - 04-28-2006 , 08:02 AM





schw wrote:
Quote:
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


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 With Quote
  #3  
Old   
Jim Kennedy
 
Posts: n/a

Default Re: OCI or OCCI - 04-28-2006 , 09:23 AM



"schw" <schwartz (AT) alpha (DOT) net.pl> wrote

Quote:
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

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 With Quote
  #4  
Old   
schw
 
Posts: n/a

Default Re: OCI or OCCI - 04-28-2006 , 09:51 AM


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 With Quote
  #5  
Old   
Amogh
 
Posts: n/a

Default Re: OCI or OCCI - 04-28-2006 , 10:19 AM


schw wrote:
Quote:
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 With Quote
  #6  
Old   
Jim Kennedy
 
Posts: n/a

Default Re: OCI or OCCI - 04-29-2006 , 09:19 AM



"schw" <schwartz (AT) alpha (DOT) net.pl> wrote

Quote:
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 With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top