❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Generate from Interactive Report and Insert into DB Table
BENNETT
Hey Vinish, I tried storing the BLOB in a temporary table, but I'm getting the same invalid LOB locator specified error. The issue seems to then be coming from the procedure.
Generate from Interactive Report and Insert into DB Table
BENNETT
Vinish, I should also add that when the attachment code is removed, the email does send successfully, so the issue lies within the blob generating procedure or the email attachment section of the PL/SQL.
Generate from Interactive Report and Insert into DB Table
BENNETT
Vinish, I added that section, but am still getting the same error. When I run the code block in SQL Workshop instead of through the dynamic action, I get the below. Line 49 of the approval_csv procedure is the raise line and line 37 is the beginning of the dbms_lob.converttoblob( ) line. Line 10 isRead more
Generate from Interactive Report and Insert into DB Table
BENNETT
Vinish, The code update worked! The procedure compiled successfully. I put it into the dynamic action I'm using to send the email, and that code compiles, but then when I run it I'm getting an error saying: Ajax call returned server error ORA-06502: PL/SQL: numeric or value error: invalid LOB locatoRead more
Generate from Interactive Report and Insert into DB Table
BENNETT
Vinish, Thank you for your quick response. I added my own query to the middle section, and am coming across a response saying 36/17 PLS-00382: expression is of wrong type. The query itself compiles just fine when I run the code between SELECT Xmlcast ... fqa.allocation_pct desc. The line 36 being reRead more
Generate from Interactive Report and Insert into DB Table
BENNETT