Running a PHP script when a new row is added to an Oracle table

[chathura86]

Hi,

I want to a run a php script when a new record is added to a table in Oracle.

Please tell me how?

Thanks

Chathura Bamunusinghe

[pbmods]

Heya, Chathura.

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

How is the data being added to the Oracle table?

[chathura86]

Heya, Chathura.

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

How is the data being added to the Oracle table?

First of all thanks for the advise.

Well data is being added by another application (VB application, code is not available) using barcode readers.

regards

[pbmods]

Heya, Chathura.

Ah. Ok.

I'm going to go ahead and move this thread to the Oracle forum, where our resident Experts will be better able to help you out.

[chathura86]

Heya, Chathura.

Ah. Ok.

I'm going to go ahead and move this thread to the Oracle forum, where our resident Experts will be better able to help you out.

ok thanks,
i'm looking fowerd for that.

Thanks

[debasisdas]

You can do that at the time of inserting new record through front end .

or

Through an After insert Trigger on the database table.

But ,I am not sure how to call PHP script from VB or ORACLE.

[chathura86]

You can do that at the time of inserting new record through front end .

or

Through an After insert Trigger on the database table.

But ,I am not sure how to call PHP script from VB or ORACLE.

cannot do it through the front end.can done only after it is being insert to the
ORACLE table.

but if it can be done through VB.NET then i can manage the rest.
and i also dont know how to configure a ORACLE triger to execute a VB
script.

Thanks.

[amitpatel66]

cannot do it through the front end.can done only after it is being insert to the
ORACLE table.

but if it can be done through VB.NET then i can manage the rest.
and i also dont know how to configure a ORACLE triger to execute a VB
script.

Thanks.

Unfortunately, Oracle does not include any native way to execute VB code from within the database. This includes triggers, functions, procedures, and any PL/SQL block. Oracle does provide the ability to run external C++ routines and Java within the database. In order to run the VB code, you'll have to make your trigger run either an external C++ routine or Java and then have that routine run your VB code as host callout.

[chathura86]

Unfortunately, Oracle does not include any native way to execute VB code from within the database. This includes triggers, functions, procedures, and any PL/SQL block. Oracle does provide the ability to run external C++ routines and Java within the database. In order to run the VB code, you'll have to make your trigger run either an external C++ routine or Java and then have that routine run your VB code as host callout.

calling a C++ routine is also fine. please tell me how to config the ORACLE
to run a C++ routine.

Thanks.