Can the newly written stored procedure in Oracle replace the original stored procedure with the same name? Even if the o

咖啡牛

Suppose you don't know the parameters of the encrypted stored procedure, but only the stored procedure name. Is there a way to get the parameter information?
    If you can, you can replace the original stored procedure with a stored procedure with the same name.

    Now, my colleague uses the Oracle stored procedure to verify the legitimacy of the web server (check if the IP and machine information are in the predetermined table). If the above is feasible, this test can be easily broken.

hzy520cf

Can be replaced with create or replace.

whbilly

create or replace can

nature

In the encryption process, the process name will not be encrypted, just CREATE OR REPLACE is enough.

terrorlin

I do not know the parameters of the encrypted stored procedure, only the name of the stored procedure

In this case, I think create or replace will not overwrite the original. Because you only know a name, what you recreated with that name is just an overload,,,, (as far as I know now, at least that)

terrorlin

Of course, the premise is that the encrypted stored procedure has parameters

咖啡牛

Is there a way to view the stored procedure name in Oracle?