Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Accessing Oracle Global variables in Servlets/JSP

 
Malli Raman
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is it possible to access Oracle global variables in the JSP and Servlets.
For example ,
EmployeeCounter is a oracle global variable,
Can I access this counter in jsp/servlet.

Regards,
M.S.Raman
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you could write a pl/sql function that returns the value, then call it from java using CallableStatement()
 
Remesh Govind
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
You may want to USE PL/SQL . Create PKG/FUCN and USE in/out vars in this .
Regards
Remesh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic