LEHS / Feature Requests / #1 Prepared Statement with Logging

#1 Prepared Statement with Logging

Milestone: Release 2.1

Status: open

Owner: Mufasa1976

Labels: new Interfaces (2)

Priority: 5

Updated: 2010-05-27

Created: 2010-03-22

Creator: Mufasa1976

Private: No

Develop a new API (PKG_LEHS_PREPARED_STATEMENT) which provides the functionality of a Java Prepared Statement (with Setters) for dynamic Statements. To do this, the new 11g Feature DBMS_SQL.to_refcursor can be used. Drawback: Only usable for Database 11g and above.

This API can also to log the Statement. The Parameters of the Statement can be stored as a nested Table on LEHS_LOG_TABLE_BASIC.

Discussion

Mufasa1976 - 2010-03-25

labels: 1182670 --> new Interfaces
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Mufasa1976 - 2010-03-31

status: open --> pending
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

SourceForge Robot - 2010-04-15

status: pending --> closed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

SourceForge Robot - 2010-04-15

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Mufasa1976 - 2010-05-27

status: closed --> open
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Prepared Statement with Logging

Group

Searches

Help

#1 Prepared Statement with Logging

Discussion