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 vote124 views1 answer
Oracle character index
SQL
0 vote128 views1 answer
Utiliser sql ligne de commande
SQL
0 vote127 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
2 votes134 views3 answers
Current setting postgres timezone
SQL
5 votes82 views1 answer
Mongodb vs
SQL
0 vote137 views1 answer
Sql change column in existing table
SQL
0 vote181 views1 answer
ORA-01400
SQL
0 vote164 views3 answers
Characters found after end of sql statement
SQL
16 votes133 views1 answer
CTE statement sql server
SQL
3 votes120 views1 answer
Two selects in one query
SQL