Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

1st SchemaTable's "On Data Change" --> Update another Schema.another Table

KnightbeatFeb 22 2010 — edited Feb 22 2010
I need to know how to write a trigger so that it listens to a table*(table 1)* of one schema & immediately updates another table(table 2) which exists in another schema, on any data change (record insert/update or delete) in the 1st table I mentioned.

[I didn't read anything about this before I ask this. So I just need to know whether it's possible or not. I don't expect you to spend a lot of time on this. But I will be much thankful, if you could tell me whether this is possible to be done or not]

Thanks!

Comments

karianna

This Q should be moved to the Java Security community, but it looks like you have a classpath issue where that class/method is not being loaded.

Pankaj Shakya

Thanks @"karianna", but while i type complete path in url, all jars are being accessed.

e.g http://10.25.85.74:8080/PIMS/applet/dsc-1.0.jar

Is there any problem with my JNLP file?

karianna

I'm not familiar with JNLP - perhaps it needs download="eager" on the bouncy castle lib and you should also check that the bouncy castle JARs actually contain the method you're invoking.

Pankaj Shakya

I have already tried it with eager...but no change and  checked all jars, they are containing all methods and classes which are being invoked. I have been working on this problem since last 3 days, all the solutions which i found weren't helpful. Also tried oracle demo of Java Web Start, i am doing the same as mentioned.

I have also got a ref site, downloaded jnlp and when tried to execute - The same problem was there.

https://www.qoppa.com/files/pdfnotes/demo/jPDFNotes_savetoweb.jnlp

Pankaj Shakya

I have already tried it with eager...but no change and  checked all jars, they are containing all methods and classes which are being invoked. I have been working on this problem since last 3 days, all the solutions which i found weren't helpful. Also tried oracle demo of Java Web Start, i am doing the same as mentioned.

I have also got a ref site, downloaded jnlp and when tried to execute - The same problem was there.

https://www.qoppa.com/files/pdfnotes/demo/jPDFNotes_savetoweb.jnlp

user13654132

Do you still solve dthis problem? cause im having the same issues here. Webutil function works fine when using browser but problem when using webstart.

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 22 2010
Added on Feb 22 2010
#on, #sql, #trigger, #update
2 comments
424 views