Function plsql

CREATE OR REPLACE FUNCTION my_schema.my_function(param1 IN number) RETURN output1 IS
    cnumber NUMBER;
BEGIN
    cnumber := 2;
    RETURN (cnumber * param1);
EXCEPTION
    WHEN OTHERS THEN
        raise_application_error(-20001, 'An error was encountered - '
            || sqlcode || ' -ERROR- ' || sqlerrm);
END;

Similar codes

0 vote241 views1 answer
Pl sql search saurce code
SQL
0 vote287 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote267 views1 answer
Python connect to mysql in settings.py
SQL
0 vote248 views1 answer
Limiting query result using where in sql
SQL
0 vote301 views1 answer
Psql check if sql script is valid
SQL
2 votes269 views1 answer
Use cases condition in sql query laravel
SQL
0 vote246 views1 answer
Oracle archivemode
SQL
0 vote260 views1 answer
How to change null display in psql
SQL
4 votes271 views1 answer
Data types in sql
SQL
0 vote245 views1 answer
Check duplicate values plsql
SQL