Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • Last Modified:

Fire Oracle triger from VB

How can I fire a triger that I have in Oracle from VB application?

thanks.
0
Stella
Asked:
Stella
1 Solution
 
jrspanoCommented:
i am know very little about oracle, but if it is any thing like sql server you can't just call a trigger.  they are designed to activate when you insert, delete, or update rows in the table they are associated with.  you need a stored procedure if you want to call it.
0
 
StellaAuthor Commented:
jrspano,
Thanks for your response. My problem is that the triger which is in Oracle database does not activated when I insert record, but it should. I can see my records in a database, but without any changes that triger should do. That's why I wondering how I can call that triger from VB by writing a module to do that.
0
 
jrspanoCommented:
i would think that the trigger is written wrong then.  it should fire every time you insert a row nomatter how you do it.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
StellaAuthor Commented:
jrspano,

The triger is written fine and it's working with a different application that uses the same database. Any ideas why it's not fire when I insert records from VB application?
thanks
0
 
jrspanoCommented:
how are you sending data to the db.  if you arn't doing it try to send it in sql statements. in ado
connection.execute sql
0
 
StellaAuthor Commented:
I am using Dao connection. And I am saving the records with recordset.addnew. Do you think that it will work if I rewrite it using SQL string and execute it???
0
 
jrspanoCommented:
i would give that a try.  pick an easy one and give it a try. I always use sql so i don't know if the .addnew is what is doing it or not.  I do know that my sql always works with triggers on sql server.
0
 
DanRollinsCommented:
Hi Stella@devx,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:

    Accept jrspano's comment(s) as an answer.

Stella@devx, if you think your question was not answered at all or if you need help, you can simply post a new comment here.  Community Support moderators will follow up.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
Computer101Commented:
Comment from expert accepted as expert

Computer101
E-E Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now