| Using CLOB/BFILE to store payslips [message #409509] |
Mon, 22 June 2009 23:59  |
virmahi
Messages: 266
Registered: April 2008
Location: India
|
Senior Member |
|
|
Hi,
I have to store payslips in database....in some folders that should get named as 10000 for first 10000 payslips and then another folder should get automatically created for 10001 to 10999 payslips in folder named 20000. The table is created as
CREATE TABLE PAYSLIP_MASTER
(
PK_PSM_ID NUMBER(20,0) NOT NULL,
PK_PSM_NAME VARCHAR2(20) NOT NULL,
PSM_PAY CLOB,
PSM_CREATE VARCHAR2(100),
PSM_MODE VARCHAR2(100),
PSM_CREDIT TIMESTAMP(6)
)
The data against the column PSM_PAY comes as a path like
D:\oracle\product\10.2.0\oradata\PAYPLUS\lobs\payplus_payslip_master\payplus_payslip_master.0
D:\oracle\product\10.2.0\oradata\PAYPLUS\lobs\payplus_payslip_master\payplus_payslip_master.1
D:\oracle\product\10.2.0\oradata\PAYPLUS\lobs\payplus_payslip_master\payplus_payslip_master.2
The filenames like 'payplus_payslip_master.2' in range from payplus_payslip_master.0 to payplus_payslip_master.10000 should be stored in a folder named 10000 and file ranging from 10001 to 20000 in folder named 20000 and so on....and should get happening like this when data grows....with creation of new folders....
I have basic knowhow of CLOB but here I am not sure how to go about the client requirement.
Please give me some insight if anyone has done something similar to this.
Regards,
Mahi
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
