PL/SQL (MOSC)

MOSC Banner

pls-00653 error when trying pipelined table function

edited Jul 21, 2016 1:31PM in PL/SQL (MOSC) 4 commentsAnswered

Hello I am trying to use a pipelined table function.

I have created the object:

<span class="kwd">CREATE</span><span class="pln"> </span><span class="kwd">OR</span><span class="pln"> REPLEACE TYPE emp_time </span><span class="kwd">AS</span><span class="pln"> OBJECT </span><span class="pun">(</span><span class="pln">SUN_HOURS NUMBER</span><span class="pun">(</span><span class="lit">8</span><span class="pun">,</span><span class="lit">2</span><span class="pun">),</span><span class="pln"> MON_HOURS NUMBER</span><span class="pun">(</span><span class="lit">8</span><span class="pun">,</span><span class="lit">2</span><span class="pun">),</span><span class="pln"> TUE_HOURS NUMBER</span><span class="pun">(</span><span class="lit">8</span><span class="pun">,</span><span class="lit">2</span><span class="pun">),</span><span class="pln"> WED_HOURS NUMBER</span><span class="pun">(</span><span class="lit">8</span><span class="pun">,</span><span class="lit">2</span><span class="pun">),</span><span class="pln"> THU_HOURS NUMBER</span><span class="pun">(</span><span class="lit">8</span><span class="pun">,</span><span class="lit">2</span><span class="pun">))</span>

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