search

rstenet / 9i-unwrapper

Unwrap wrapped PL/SQL codes for Oracle database 9i (and probably below)
MIT License
2 stars 1 forks source link

error when exec to unwrapper a package #1

Open baldu2021 opened 2 years ago

baldu2021 commented 2 years ago

When you try it with a package, the following code trigger error because return more than 1 row

select max(line) into l_number_of_lines from user_source where name = upper(p_name) ;

And that is because for object like ackage you will have 2 sources: one of the package declaration and one of the package body.

I really don't know much about pl / sql to fix it.

rstenet commented 2 years ago

The current code V1 works with functions and procedures only. One can fix the number of rows returned easily. However, that would only be half the job without implementing the required DIANA nodes.

I'm working on support for PACKAGE and PACKAGE BODY, but the priority is quite low, as I have some REAL projects and I don't need it right now.