Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aylin_sk
Starting Member
25 Posts |
 Posted - 2005-03-30 : 04:59:00
|
| According to this sql, I got the error like:ERROR:ORA-01790 expression must have same datatype as corresponding error..And this error points the red code...select MARSEG.PEOPLE_PKG.GET_PERSON_FULLNAME(P_PERSON_ID) P_PERSON_FULLNAME, P_UNIT_ID, MARSEG.CUSTOMERS_PKG.GET_CUSTOMER_FULLNAME(P_PHYSICIAN_ID) P_PHYSICIAN_FULLNAME, P_PATIENT_NAME, P_DIAGNOS_ID, P_ENDICATION_ID, P_USEOFGLIVEC_ID, P_PRODUCT_ID, P_FORM_ID, P_DOZE, P_OTHER_THERAPIES_ID from OPFS.PATIENTS where P_PRODUCT_ID = 'GLIVEC' union select 'TS', 'Kurum Adý', 'Dr.Adý', 'Hasta Adý', 'Taný', 'Endikasyon', 'Glivec Kullanýmý', 'Ürünler', 'Formlar', 'Doz', 'Diðer Tedaviler' from dual; |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-03-30 : 05:11:47
|
| You'd probably be better off asking on an oracle forum, but just as a guess I'd say that the data type that you are trying to UNION with another data column is not the same. So you'd need to convert one or the other.-------Moo. :) |
 |
|
|
|
|
|
|
|
Error