SQL*Plus (MOSC)

MOSC Banner

Run and compile pls package

edited Jun 25, 2013 4:19AM in SQL*Plus (MOSC) 9 commentsAnswered
Can anyone help me with how I can run and compile a pls package using SQL Plus.

I have been researching about automating a mapping with Order Type and Salesperson - Unable To Default Salesrep Based On Order Type [ID 1260704.1].
I have added the suggested code to the PL/SQL script and have tried to compile it using Toad but it gets stopped at a REM line - REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb checkfile(115.6=120.0):~PROD:~PATH:~FILE and is asking for a Variable for &phase.

It was then suggested I run it in SQL Plus but am not sure how to do this.  I copied the file to my C:\ drive and logged in and typed

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