SQL*Plus (MOSC)

MOSC Banner

Passing parameters from concurrent program to SQL*plus mode script

edited Mar 5, 2014 11:23PM in SQL*Plus (MOSC) 2 commentsAnswered ✓

Hi All,

I am trying to fetch parameter passed from concurrent program to my sql script.

I am trying to assign that value to one variable but it is not happening.

l_employee_number := '&&1';

FND_FILE.PUT_LINE(FND_FILE.LOG, 'Execution for employee number :=' || l_employee_number);

Output :

Execution for employee number :=&&1

Data type for parameter is CHAR and variable is VARCHAR.

I want to print exact employee number which is passed from application.

Details :

RDBMS : 11.2.0.2.0

Oracle Applications : 11.5.10.2

Thanks and Regards,

Piyush Ojha

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center