OraFAQ Forum: Programming Interfaces » Can i execute PLSQL Block in an Servlet Code.

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.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can i execute PLSQL Block in an Servlet Code. [message #534819]

Fri, 09 December 2011 07:22

mukuljain549
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.

Report message to a moderator

Re: Can i execute PLSQL Block in an Servlet Code. [message #534820 is a reply to message #534819]

Fri, 09 December 2011 07:27

ThomasG
Messages: 3212
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.

Report message to a moderator

Previous Topic:	Connect Oracle with PHP in 64 bit machine
Next Topic:	How we can connect MS-Excel to Oracle?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 06:52:00 CST 2025