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

-2 votes229 views2 answers
Union all in sql
SQL
0 vote218 views1 answer
Oracle merge insert if not exists
SQL
8 votes219 views1 answer
Today minus 15 days postgresql
SQL
0 vote232 views1 answer
Sql tabelle erstellen
SQL
2 votes215 views4 answers
Duplicate record mysql
SQL
0 vote222 views1 answer
Flask sqlalchemy session delete
SQL
0 vote216 views1 answer
Codigo crear tablas sql server
SQL
1 vote222 views1 answer
How to use a trigger to validate input data
SQL
7 votes220 views1 answer
Mysql iif
SQL
10 votes253 views6 answers
Mysql set root password
SQL