Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed Forums > Databases > Oracle Development
Reload this Page

PL/SQL PROCEDURE using CURSOR LOOPS


Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old April 1st, 2012, 03:50 PM
LearningCode LearningCode is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2012
Posts: 5 LearningCode User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 50 m 29 sec
Reputation Power: 0
Sql
**
Last edited by LearningCode : April 2nd, 2012 at 10:18 AM. Reason: no one answered my question, ILL BE MOVING IT TO A 'PROPER' FORUM
Reply With Quote
  #2  
Old April 1st, 2012, 04:09 PM
SimonJM SimonJM is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
  
Join Date: Mar 2006
Posts: 2,108 SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level)SimonJM User rank is General 8th Grade (Above 100000 Reputation Level) 
Time spent in forums: 1 Month 1 Week 1 Day 4 h 41 m
Reputation Power: 1485
Requested move to correct (Oracle) forum
__________________
The moon on the one hand, the dawn on the other:
The moon is my sister, the dawn is my brother.
The moon on my left and the dawn on my right.
My brother, good morning: my sister, good night.
-- Hilaire Belloc
Reply With Quote
  #3  
Old April 1st, 2012, 04:14 PM
LearningCode LearningCode is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2012
Posts: 5 LearningCode User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 50 m 29 sec
Reputation Power: 0
Quote:
Originally Posted by SimonJM
Requested move to correct (Oracle) forum


But the question iv asked is to do compltely with MYSQL, so therefore I placed it in the MYSQL section? How do I move it then?
Reply With Quote
  #4  
Old April 1st, 2012, 04:48 PM
shammat shammat is offline
Contributing User
Dev Shed Frequenter (2500 - 2999 posts)
  
Join Date: Oct 2003
Location: Germany
Posts: 2,685 shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 44 m 49 sec
Reputation Power: 284
Quote:
Originally Posted by LearningCode
But the question iv asked is to do compltely with MYSQL
Why do you think code you have written in Oracle's stored procedure language that is producing an Oracle error message has anything to do with MySQL?

Btw: you should not use the CHAR datatype.
I'm pretty sure that you want VARCHAR instead.
Reply With Quote
  #5  
Old April 1st, 2012, 04:53 PM
LearningCode LearningCode is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Apr 2012
Posts: 5 LearningCode User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 h 50 m 29 sec
Reputation Power: 0
Quote:
Originally Posted by shammat
Why do you think code you have written in Oracle's stored procedure language that is producing an Oracle error message has anything to do with MySQL?

Btw: you should not use the CHAR datatype.
I'm pretty sure that you want VARCHAR instead.


OK thanks for the tips, Ill close this thread now and move it to the correct place
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Oracle Development > PL/SQL PROCEDURE using CURSOR LOOPS

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap