error creating an external table in a procedure triggered by file watcher.
I'm hoping someone can provide me some insight as to what is going with my procedure tied to a file watcher.Basically I'm watching a directory for uniquely name files fitting a pattern, I then wish to create an external table on that file, insert the contents into a main table and then drop that table.
The file watcher triggers properly and runs the associated job that executes the procedure below.
I've tested the procedure standalone and it works flawlessly.
I've verified that the string assigned to the variable sql_stmt does work in the execute immediate statement.
I'm getting the following in the run log in the filewatcher job.
The file watcher triggers properly and runs the associated job that executes the procedure below.
I've tested the procedure standalone and it works flawlessly.
I've verified that the string assigned to the variable sql_stmt does work in the execute immediate statement.
I'm getting the following in the run log in the filewatcher job.
0