... its extension (eg. "C:\Temp\SourceFiles\File00001.txt" - although I used a network share without any issues)
Add a Connection Manager
Right-click in "Connection Managers"
Select "New Flat File Connection..." ...
... still an error it would seem.
-- Error I was getting
ORA-20001: 1234567:$:ORA-01403: no data found
ORA-06512: at "BASETABLEOWNER.MY_STUPID_PROCEDURE", line 56
ORA-01403: no data found
ORA-06512: ...
... -- ending that second begin I had after my variable declaration
END;
EXCEPTION
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR (-20001, p_STUDENT_ADNAME || ':$:' || SQLERRM, ...
... open c1;
fetch c1 into student_no;
if c1%notfound then
student_no := 0;
end if;
close c1;
RETURN student_no;
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001,'An ...
... took : 0.25045800209045 Seconds
Count By Array Functions took : 1.1077101230621 Seconds
Count By preg_split+Count took : 0.30741000175476 Seconds
Count By substr_count took : 0.21060705184937 ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.