My Oracle Support Banner

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 and later
SQL*Plus - Version and later
Information in this document applies to any platform.
***Checked for relevance on 17th Jul 2017***


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.