Hi Saf, you said your sp was in a file. you must put your sp in some package of your oracle database and compile it. then you can execute in your sql+. Have a good weekend.
Thanks Saf. But they have decided to embed pl/sql string into java code, i have to change my code to use string replace calling stored procs. i feel not so happy, but have to do it. Anyway, thanks a lot. i'll use your suggestion in my next project. Take care
I am working on a project with lots of data insert,update and select from or to Oracle 8i. I created a bunch of stored procs in Oracle package to handle these tasks and in Java code i use Callable statement to call these stored procs, of couse i have to set up all the parameters first. but my boss suggests to use strait PL/SQL in java code, pass to Oracle as a string through JDBC, so will gain the performance by without set up all the parameters. I'm not very sure about his suggestion, does that mean passing PL/SQL as a string to database is better than call stored procs? Thanks a lot
Hi tim, I change my code using JPanel, I can run the applet in appletViewer, when i run in the browser(IE), this time it doesn't pop up another window, but in the browser i see nothing, just tell me 'Applet Started'. BTW, i am using JRE1.3.1 Thanks
when i run my html page, it always opens another window to run the Applet, How can i keep the Applet into the browser with my html contents. (I use java plug-in 1.3 and htmlConverter to transform my html page) Thanks
I fixed that problem in such a way: 1.Download JRE1.3 (Plug in 1.3) and install it. 2.Download HTML converter 1.3 and install it. 3.Run the HTML converter1.3 to transform all the HTML files using JApplet.