Expand To Show Full Article
Oracle Error PLS-00591: this feature is not supported in client-side programs - Developer Publish

Oracle Error PLS-00591: this feature is not supported in client-side programs

Oracle Error Message

PLS-00591: this feature is not supported in client-side programs

Reason for the Error

One of the following features was used in a wrong context: pragma AUTONOMOUS_TRANSACTION, dynamic SQL statements, (e.g. EXECUTE IMMEDIATE), and bulk binds. These listed features can only be used in server-side programs but not client-side programs.

Solution

Remove it or define a server-side subprogram to do the work and call the subprogram from the client.