Posted By: PV (Blaaaa...) on 'CZdatabases'
Title:     FW> Oracle a balicky
Date:      Fri Sep  3 16:39:30 1999

Nazdar lidi,

mam problem na oraclu Oracle7 Server Release 7.3.4.3.0, v PL/SQL Release
2.3.4.3.0

Mam balicek, ktery vypada nasledovne:

CREATE PACKAGE balicek AS
  PROCEDURE mojeproc;
END balicek;
/
CREATE PACKAGE BODY balicek AS

  PROCEDURE vlozeni (s IN INTEGER) IS
  BEGIN
    INSERT INTO CislaTemp VALUES (s);
  END;

  PROCEDURE mojeproc IS
    CURSOR c1 IS SELECT * FROM CISLA;
    Cislo INTEGER;
  BEGIN
    OPEN c1;
    LOOP
      FETCH c1 INTO Cislo;
      EXIT WHEN c1%NOTFOUND;
      VLOZENI (Cislo);
    END LOOP;

  END mojeproc;

END;
/


Kdyz ho natahnu, zda se byti vse v poradku:

SQL> @bal2
Package created.
Package body created.

Ale kdyz jej chci spustit, objevi se nasledujici:

SQL> execute mojeproc
begin mojeproc; end;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'MOJEPROC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Co s tim?

A jeste jeden dotaz: k cemu tam slouzi ta lomitka?

Diky za odpovedi






.-----------------------------------------------------------------------------.
|  ,,Problem je vzdy mezi zidli a klavesnici``     _                     PV   |
|  mail: bla@atrey.karlin.mff.cuni.cz          _ "-()---------------)   alias |
|  http: atrey.karlin.mff.cuni.cz/~bla        (_)  '-"~~~~~~~~~~~~~-'    Bla  |
`-----------------------------------------------------------------------------'