Quote:
Originally Posted by jisha
Hi All,
How to access the postgreSQL from a perl script?
Thanks in advance
JS
|
The following method is used to connect plsql from the Bash:
sqlplus -l USERNAME/PASSWORD@DBNAME <<EOF
insert into TABLE_CFS_DUMP(FILE_NAME, REGION_ID, SDP_ID, SEQUENCE_ID, TOTAL_RECORDS) values ('$file','$region_id','$sdp_id','$sequence_id', '$sub_records');
EXIT
EOF