Home » Open Source » Programming Interfaces » Can i execute PLSQL Block in an Servlet Code. (Java 6.0, Apache web Server6.5, window Xp 32 bit.)
icon7.gif  Can i execute PLSQL Block in an Servlet Code. [message #534819] Fri, 09 December 2011 07:22 Go to next message
Messages: 3
Registered: December 2011
Location: Mumbai
Junior Member

hi all,

I m Stuck in a Problem.

I m developing a tool on window Xp in java servlet.

This servlet accessing Oracle db. when i execute SQL statment in servlet page its working fine.

but when i write an PLSQL block at the place of SQL statement.

Its showing error.

Please suggest me can i write PLSQL block in servlet codeing.

Can i write PLSQL Block with in JSP.

Re: Can i execute PLSQL Block in an Servlet Code. [message #534820 is a reply to message #534819] Fri, 09 December 2011 07:27 Go to previous message
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Yes, you can. But you shouldn't.

JSP should be the presentation layer, the database access itself should be in a Java class.
Previous Topic: Connect Oracle with PHP in 64 bit machine
Next Topic: How we can connect MS-Excel to Oracle?
Goto Forum:

Current Time: Fri Feb 23 20:10:28 CST 2024