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

11 votes775 views4 answers
Reset identity column values in sql server
SQL
0 vote317 views1 answer
Minecraft duping allowed servers
SQL
5 votes320 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote326 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote327 views1 answer
Inner joint
SQL
3 votes316 views1 answer
Oracle limit user tablespace
SQL
1 vote330 views1 answer
Sql exclude duplicates and find even id
SQL
46 votes394 views4 answers
Create column sql
SQL
8 votes364 views2 answers
Update sql server from another table
SQL
0 vote319 views1 answer
Add alternate add column sql
SQL