accessing oracle data through sas

《accessing oracle data through sas》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、AccessingORACLEdatathroughSASSusanneYoungBankOneOverviewYouneedtouseSAStoaccessdatastoredinOracletablesorviewsOptionsLIBNAMEstatementpass-thruSQLqueryLIBNAMEstatementLIBNAMEMYORALIBORACLEUSER=MYUIDPW=MYPASSWORDPATH='@OraInfo'SCHEMA=MYSCHEMA;LIBNAMEstatement14LIBNAMEMYORALIBORA

2、CLEUSER=MYUIDPW=XXXXXXXPATH='@OraInfo'SCHEMA=MYUIDNOTE:LibrefMYORALIBwassuccessfullyassignedasfollows:Engine:ORACLEPhysicalName:@OraInfoLIBNAMEstatementLIBNAMEstatementPROCPRINTDATA=MYORALIB.NBR_DAYS_TO_DATE_LKUP;RUN;LIBNAMEstatementHelpfulInfoAutomaticmacrovariables&sysdbmsgd

3、isplaystheDBMSerrormessages58%put&sysdbmsg;ORACLE:ORA-01017:invalidusername/password;logondenied&sysdbrcdisplaystheDBMSerrorcodes59%put&sysdbrc;-1017SqlpassthruqueryPROCSQL;CONNECTTOORACLE(USER=MYUIDORAPW=MYPASSWORDPATH='@OraInfo');SELECT*FROMCONNECTIONTOORACLE(SELECT*FROMMYSC

4、HEMA.NBR_DAYS_TO_DATE_LKUP);DISCONNECTFROMORACLE;QUIT;SqlpassthruquerySqlpassthruqueryExecutestatementexecute(grantselectonMYSCHEMA.MY_TABLEtoOTHERUID)byoracle;execute(executecredit(234,5000))byoracle;execute(createuniqueindexmy_pkonMYUID.MY_TABLE(MYFIELD))byoracle;Execute(dro

5、ptableMYUID.MY_TABLE)byoracle;SqlpassthruqueryAutomaticmacrovariables&sqlxmsgdisplaystheDBMSerrormessages64%put&SQLXMSG;ORA-12560:TNS:protocoladaptererror&sqlxrcdisplaystheDBMSerrorcodes65%put&SQLXRC;-12560WhatyouneedtoknowPath=optionWhatyouneedtoknowWhatyouneedtoknowSchema=op

6、tionInMicrosoftAccess,whenconnectingtoOracletables,theSchemanameisidentifiedasthetexttotheleftoftheperiod.Thebestwaytofindoutistogotothesource,yourOracleDBAErrorMessagesTheserviceyou’rereferencingisnotconfiguredinyoursqlnet.orafile.ERROR:ORACLEconnectionerror:ORA-12154:TNS:cou

7、ldnotresolveservicename.ERROR:ErrorintheLIBNAMEstatement.YoudonothaveSAS/AccessforORACLEorit’snotconfiguredproperlyERROR:TheSAS/ACCESSInterfacetoORACLEcannotbeloaded.TheSASORAcodeappendagecouldnotbeloaded.ERROR:ErrorintheLIBNAMEstatement.ErrorMessagesYou’veenteredyourUserIDorp

8、asswordincorrectlyorit’sexpired.ERROR:ORACLEconnectionerror:O