![]() ![]() ![]() ![]() I think my IF - THEN followed by the INSERT statement is correc - it is woring. Once I get one working example, I'm sure I can get the idea and continue on. I asked this on another site and got back lots of answers that I tried and did not work due to different errors. Within the procedure you can use all the keywords you want. If someone can tell me exactly how to test I would appreciate it. SELECT Directors_Seq.CURRVAL INTO vNewDirectorID FROM DUAL SELECT Count(*) INTO row_count FROM Directors WHERE Lastname = vLastname Well use the spexecutesql command to call the dynamic query using these parameters.The updated stored procedure with changes is shown below. Please use some bogus name for the firstname and lastname values to demonstrate. You'll see that it is a straight ahead insert into the database of a firstname and lastname and there are 2 IN OUT values as well. I am probably not initializing the variables right or something - not sure. I know that the procedure works in general because I'm calling it from ColdFusion but I want to test it from SQL Developer or SQL Plus before I call it from my ColdFusion page - this only makes sense. I've been through the documentation - and through it again - and I am just not getting it. parameters are stored locally, and Rapid SQL Developer can be set to connect. Please don't refer me to the documentation or offer some kind of pseudo code. run them better, regardless of their platform or programming language. Can someone provide me with the EXACT command to run to test my stored procedure presented below. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |