oracle - PLSQL Function that doesn't raise exception properly -

-

i writing function return student's name when id entered. if id entered, doesn't exist in database, want exception raised. instead when enter incorrect student ids either returns nothing if have basic exception thrown or returns error message exception declared:

6503. 00000 -  "pl/sql: function returned without value" *cause:    call pl/sql function completed, no return statement        executed. *action:   rewrite pl/sql function, making sure returns        value of proper type.

here's function:

create or replace function student( s_num in number) return varchar2 student_name varchar2(50); notexists   exception;    cursor s_cur    select s_name       roster       s_num = s_id; begin    open s_cur;    fetch s_cur student_name;     if s_cur%notfound       raise notexists;    end if;    close s_cur; return student_name;  exception when notexists -- handle error       dbms_output.put_line('no student found.'); end;

any ideas?

when exception occurs, not returning actual error message.your function supposed return varchar. printing error , not returning actual error message.

exception when notexists -- handle error       dbms_output.put_line('no student found.');       return 'no student found' end;

Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more