plsql - Calling package's procedure from another procedure -

trying search couldn't find it.

i have package name package_1 , in have multiple procedures/functions. want call 1 of these functions procedure, not part of package. can't put code in package (both on same schema).

i trying this

package_1.function_1(varchar_var_1, varchar_var_2, varchar_var_3);

but giving me error.

question2 above functions return object record type defined in package. how can declare object of type in procedure can assign response in procedure ?

if function returns record type, you'd need declare local variable in caller of record type. like

create or replace procedure your_procedure_name( <<parameters>> )   l_rec package_1.record_type;   ... begin   ...   l_rec := package_1.function_name( p1, p2, p3 );   ... end; 

of course, assumes both record type , function defined in package spec public rather merely being defined private members of package defined in package body.