How To Pass a Parameter From A UNIX Shell Script To A PLSQL Function Or Procedure

(Doc ID 351015.1)

Last updated on JULY 17, 2017

Applies to:

PL/SQL - Version 9.2.0.8 and later
SQL*Plus - Version 9.2.0.8 and later
Information in this document applies to any platform.
***Checked for relevance on 17th Jul 2017***


Goal

How to execute in a Unix/Linux shell script a PL/SQL stored function or procedure that receives a parameter from the shell script and returns a value to the shell script.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms