-
I have been trying to put the following line into a spool file:
execute send_mail('sheryl@acme.com','sheryl@test.com','TEST SUBJECT','PROD:USERS is 75% used');
by the following sql:
dbms_output.put_line('execute send_mail('''||send_address||''','''||rec_address||''','''TSA Alert''','''||dbname||''': '''||tbsname||''' is '''||bytes_pct||'''% used''');');
(where :
send_address := 'sheryl@acme.com'
rec_address := 'sheryl@test.com'
dbname := 'PROD'
tbsname := 'USERS'
bytes_pct := '75')
But I get the following error:
ORA-01756: quoted string not properly terminated
I have now been working on this all day, by adding or removing the single quotes, even using chr(39), but still can't seem to crack this. Can anyone please help?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|