Database Administration (MOSC)

MOSC Banner

ERROR: ORA-29283

edited Sep 19, 2020 5:02AM in Database Administration (MOSC) 1 commentAnswered

My goal is to convert/create a txt file the records created to my table

Normally what I do is run report, generate to file then delimited then save to a txt file, but to cut the process I want to immediately create a textfile.

I use UTL_FILE but I encounter this error ORA-29283 everytime. Below is my whole script

PROCEDURE create_text_file IS

cursor c is

select  b.agent_cd,

upper(ACCT_NAME) BENE_NAME,   

upper(BANK_NAME) BENE_BANK,     

bank_acct,

nvl(MUNICIPALITY,'NA') CITY_ADDR,comm_paid,

'Commission Disbursement' OTHER_DETAILS, 'OTHERS' Tran_REASON

from ac_commpay_rqst a, ac_commpay_rqst_dtls b, m_agents_banks m1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center