CODEWITHSUNDEEP
oracle-databaseplsqlpackage
x.509
x.509

Reputation: 2235

Installing and running Pl/SQL packages

I have the package.pkg and package.pkg files, how can i install and run it without using Pl/SQL Developer? is there anyway or i have to install Pl/SQL Developer?

Upvotes: 1

Views: 9457

Answers (3)

Harrison
Harrison

Reputation: 9090

Oracle Developer is free and is produced by Oracle

http://www.oracle.com/technetwork/developer-tools/sql-developer/index.html

as mentioned elsewhere, SQLPlus is available if you have the oracle client installed.

you can also look into http://www.orafaq.com/wiki/ISQLPlus if it installed on by the dbas

Upvotes: 0

Allan
Allan

Reputation: 17429

Package scripts are just text, so any SQL interface will work. The obvious choice is SQL*Plus, the text-based interface that is part of the full Oracle client installation.

Upvotes: 0

winkbrace
winkbrace

Reputation: 2711

Or in sql*plus (which is installed together with Oracle) you type @/path/to/package.pkg. Make sure to end with a / (forward slash).

It should look something like this:

SQL> @proc.prc
SQL> CREATE OR REPLACE PROCEDURE PROC(VAL1 IN NUMBER, VAL2 OUT NUMBER)
  2  AS
  3  BEGIN
  4     VAL2 := VAL1*2;
  5  END PROC;
  6  /

Procedure created.

Upvotes: 6

Related Questions