Forum Stats

  • 3,734,269 Users
  • 2,246,935 Discussions
  • 7,857,216 Comments

Discussions

Use record to access info in another db table

TheManWhoSoldTheWorld
TheManWhoSoldTheWorld Member Posts: 123
edited May 29, 2015 9:19AM in SQL

I have a stored procedure that uses substr/instr to read a text file. I need to filter one of those extracted fields by running a check against a table in another database. The extracted fields are in a record. Can i do a cross-db check using records? I do have access to cross check against the other database.

Lets say Invoice Num 12345 is one of the extracted records. I need to check in Database 2 if that Invoice Num actually exists in the Database 2 table before further processing. Invoice Num and all the other information from the file are extracted into a record.

Thanks!

Tagged:
Sign In or Register to comment.