Home » SQL & PL/SQL » SQL & PL/SQL » Problems Wrapping package with pipelined functions (Oracle 8i, Windows XP/Linux using utility Wrap80.exe)
Problems Wrapping package with pipelined functions [message #385899] Wed, 11 February 2009 15:46 Go to next message
Donafer
Messages: 2
Registered: February 2009
Junior Member
I have a question related to wrap utility.
I am using Oracle 8i, Linux.
I followed an example of pipelined function below which works perfect:
http://www.oracle-base.com/articles/9i/PipelinedTableFunctions9i.php

I included this function in a package XX_GET_ALL_OBJECTS_PKG, and it also works.

Later I used the wrap80.exe to wrap the package body. It popsup with the following error:

C:\>wrap80.exe iname=c:\XX_GET_ALL_OBJECTS_PKG.pkb oname=c:\XX_GET_ALL_OBJECTS_PKG.plb

PL/SQL Wrapper: Release 8.0.6.0.0 - Production on Wed Feb 11 21:57:20 2009

Copyright (c) Oracle Corporation 1993, 1994, 1995, 1996, 1997, 1998, 1999. All
rights reserved

Processing c:\XX_GET_ALL_OBJECTS_PKG.pkb to c:\XX_GET_ALL_OBJECTS_PKG.plb
PSU(103,1,4,28):Encountered the symbol "PIPELINED" when expecting one of the fol
lowing:
. @ % ; is renames as character
The symbol "." was substituted for "PIPELINED" to continue.
PSU(103,1,40,10):Encountered the symbol "ROW" when expecting one of the followin
g:
:= . ( @ % ;
The symbol ":=" was substituted for "ROW" to continue.

PSU(103,1,46,27):Encountered the symbol "PIPELINED" when expecting one of the fo
llowing:
. @ % ; is as character

The symbol "." was substituted for "PIPELINED" to continue.
PSU(103,1,85,10):Encountered the symbol "ROW" when expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "ROW" to continue.

PL/SQL Wrapper error: Compilation error(s) for:
create or replace package body apps.xx_get_all_objects_pkg
Outputting source and continuing.



Could you please advice

Thanks

Kind regards
Donald
Re: Problems Wrapping package with pipelined functions [message #385901 is a reply to message #385899] Wed, 11 February 2009 15:59 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
from what I recall, pipelined functions were only introduced in 9i, try 9i wrap, not the 8.0.6 version.
Previous Topic: Tuning a query
Next Topic: date substraction
Goto Forum:
  


Current Time: Sat Dec 03 18:19:04 CST 2016

Total time taken to generate the page: 0.06219 seconds