|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Can I overload a PL/SQL procedure based on different record type with same structure
Hello:
I have two cursors like cursor_A IS select * from table_a where condition_A; cursor_B IS select * from table_a where condition_B; record_A is a recorded of cursor_A%ROWTYPE record_B is a recorded of cursor_B%ROWTYPE I define a procedure like pro_A(record_in cursor_A%ROWTYPE) can I overload this procedure by defining pro_B(record_in cursor_B%ROWTYPE)? If I can't, Can I call pro_A by passing record_B as the parameter to it? T.I.A. |
|
#2
|
|||
|
|||
|
only packages allowed overloading. write your all functions and procedures into package those need to be overloaded.
|
|
#3
|
|||
|
|||
|
Yes, I will put these procedures in a package. Can you give me some hints on my question? Thanks,
|
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Can I overload a PL/SQL procedure based on different record type with same structure |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|