calling pl/sql from shell script
hi ,
I'm inserting into a table by calling a stored procedure mytab def is
SQL> desc dbinfo.event_log_t
Name Null? Type
----------------------------------------- -------- ----------------------------
EVENT_NAME NOT NULL VARCHAR2(50)
EVENT_ID NOT NULL NUMBER(38)
EVENT_TYPE NOT NULL VARCHAR2(20)
EVENT_DATE_TIME NOT NULL TIMESTAMP(6)
EVENT_STATE NOT NULL VARCHAR2(5)
HOST_NAME NOT NULL VARCHAR2(30)
DB_SERVER_NAME NOT NULL VARCHAR2(30)
DATABASE_NAME NOT NULL VARCHAR2(30)
DATABASE_TYPE NOT NULL VARCHAR2(10)
INVOKING_USER NOT NULL VARCHAR2(20)
RETURN_CODE NOT NULL NUMBER(38)
SCRIPT_NAME NOT NULL VARCHAR2(30)
PROCESS_STARTED_DTTM TIMESTAMP(6)
EVENT_DESCRIPTION VARCHAR2(100)
APPLICATION_NAME VARCHAR2(30)
EVENT_INFO VARCHAR2(2000)
0