TASK – Create a function that returns the length of a mediatype from the mediatype table.
I am not sure how I am suppose to get the code below to work.
Below is what I currently have:
CREATE OR REPLACE FUNCTION getLength (name Varchar2)
RETURN length as
Select * INTO Length;
select getLenght(MEDIATYPE.name) from dual;
The error I get is below:
ORA-00904: “GETLENGHT”: invalid identifier
00904. 00000 – “%s: invalid identifier”
Error at Line: 67 Column: 8
I am still new to SQL so I am not sure how to approach this issue.